C
Carol
I am trying to format 12345 to 123.45, but it comes out
12345.00. Can anyone help?
12345.00. Can anyone help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
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.
the cell from general to number and selected the number of
dec. places you want.
P
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
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
O
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.
C
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.
.