Excel Geeks - TranceAddict Forums

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Excel Geeks
Pages (2): « 1 [2]

Posted by MeLLyMeL on Oct-29-2007 20:23:

quote:
Originally posted by DJ Mikey Mike
Where are you pulling this 'dollar amount' data from? An Excel spreadsheet? If so that's a piece of piss. Just highlight all cells with the 'dollar amount' values in them and go to Format -> Cells -> Number Tab -> Select 'currency' -> Select the most suitable pre-set (probably $1234.10)

Or have I got the wrong end of the stick?
Yeah

I do it from excel.

I've done it and it doesn't change!!!!!!!! uggggh super annoying.

Posted by DJ Mikey Mike on Oct-29-2007 20:44:

Mel, you're fucking shit. You're doing it wrong.

Does it just revert back to 50000 when it gets taken across to Word, or can you not even get the format right even in Excel? Post screen shots innit.

Posted by MeLLyMeL on Oct-29-2007 20:56:

quote:
Originally posted by DJ Mikey Mike
Mel, you're fucking shit. You're doing it wrong.

Does it just revert back to 50000 when it gets taken across to Word, or can you not even get the format right even in Excel? Post screen shots innit.
It reverts back to 500000.

I've changed the format to currency. It's freaking weird dude!!

I am so stuck.

Posted by MeLLyMeL on Oct-29-2007 21:14:

I got it dodo-head!

It's a toggle code.

After the "f5" you have to put \# $#,###}

then it properly put the comma in the right place and the dollar sign as well

Posted by DJ Mikey Mike on Oct-29-2007 21:21:

I told you you were doing it wrong you silly berk.

Posted by MeLLyMeL on Oct-29-2007 21:24:

quote:
Originally posted by DJ Mikey Mike
I told you you were doing it wrong you silly berk.

lol

wtf!

U told me to do it wrong. You were of NO help mikey.

I hope they take back ur certificate

Posted by DJ Mikey Mike on Oct-29-2007 21:30:

Luckily Mike was here to save the day. That's all that matters.

Pages (2): « 1 [2]