Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Applying number format from referenced cell | Excel Discussion (Misc queries) | |||
Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
Linking customer number format to a cell | Excel Discussion (Misc queries) |