Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zeros
I need my zero (0) to show. Example: I put in 24.950 (tons) and when I click
enter, it changes to 24.95. How can I get it to leave the zero (0) in? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zeros
Format cell as number with 3 decimal places
"karen" wrote: I need my zero (0) to show. Example: I put in 24.950 (tons) and when I click enter, it changes to 24.95. How can I get it to leave the zero (0) in? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zeros
Go to Format menu / cells / number / number / Decimal places change to
3. ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep Lead Zeros | Excel Discussion (Misc queries) | |||
Leading Zeros | Excel Discussion (Misc queries) | |||
Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) |