| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number entered in cell loses trailing zeros in formula bar
I am trying to copy numbers with number formatting (Ex:123.00 or 44.50) to
cells with text formatting. When I do this, the trailing zeros are lost (123.00 becomes 123, and44.50 becomes 44.5). I have tried TEXT formatting commands and the "Text To Columns" Wizard to no avail. Gene |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I force trailing zeros in an Excel cell? | New Users to Excel | |||
| Trailing Zeros | Excel Discussion (Misc queries) | |||
| How to tell if cell contains a FORMULA or user-entered number? | Excel Worksheet Functions | |||
| Keep numbers as entered with trailing zeros | Excel Discussion (Misc queries) | |||
| Formula/formatting to omit trailing zeros | Excel Worksheet Functions | |||
Threaded Mode
