number format

[Carol]

I am trying to format 12345 to 123.45, but it comes out
12345.00. Can anyone help?

 

[herman]

have you under "format" gone to "Cells" and then changed
the cell from general to number and selected the number of
dec. places you want.

 

[Peo Sjoblom]

00"."00

note that it doesn't change the number, only the display
If you want the number to change from 12345 into 123.45
put 100 in an empty cell, copy it, select your number(s) and
do edit>paste special and select divide

 

[ozzie]

-----Original Message-----
I am trying to format 12345 to 123.45, but it comes out
12345.00. Can anyone help?
.

try tools/options/fixed decimal place.

 

[Carol]

Yes, I set it to 2 decimals.

-----Original Message-----
have you under "format" gone to "Cells" and then changed
the cell from general to number and selected the number of
dec. places you want.
.