How to format this number cell automatically
 

Hi,

The actual content of the cell is 1798737148.9, but its value display in
the cell is 1798737148.
I don't want to right click the column and then set the column to be
number class with 2 decimal places manually everytime.
Do anyone know another simple option to set all the number cells to
display its full value all the time?

[Image]

Thanks for attention
Orc Thrall

How to format this number cell automatically
 

You could go to Tools on the menu bar and click on Options, this will open
the Options window, click on the Edit TAB and then check the box next to
"Fixed Decimal Places" When yo do this you will get .05 when you type 5.
To get 5 you need to type 5. or 500, this might be one way but it will be
this way on all of workbooks.



"Orc Thrall" wrote:

Hi,

The actual content of the cell is 1798737148.9, but its value display in
the cell is 1798737148.
I don't want to right click the column and then set the column to be
number class with 2 decimal places manually everytime.
Do anyone know another simple option to set all the number cells to
display its full value all the time?

[Image]

Thanks for attention
Orc Thrall