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.

___________________
Although you are far away
I know you'll always be
Near to me
Near to me

R.I.P. DarkAngel 12-16-o9

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.

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.

___________________
Although you are far away
I know you'll always be
Near to me
Near to me

R.I.P. DarkAngel 12-16-o9

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

___________________
Although you are far away
I know you'll always be
Near to me
Near to me

R.I.P. DarkAngel 12-16-o9

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

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

___________________
Although you are far away
I know you'll always be
Near to me
Near to me

R.I.P. DarkAngel 12-16-o9

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