View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Orc Thrall Orc Thrall is offline
external usenet poster
 
Posts: 1
Default 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