| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering zeros in cells
When entering zeros in a cell Excel rounds the figure to just a single 0.
What do you do if you enter 4 zeros but want the 4 zeros to be displayed? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering zeros in cells
a. FormatCellsNumber tab, Custom. In the Type box, enter 0000
or b. precede the zeros with an apostrophe; this will make the cell text. The apostrophe will not show or c. format the cell as text before you enter the zeros or... maybe more -- Kind regards, Niek Otten "jay_perry01" wrote in message ... When entering zeros in a cell Excel rounds the figure to just a single 0. What do you do if you enter 4 zeros but want the 4 zeros to be displayed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering zeros in Excel | Excel Discussion (Misc queries) | |||
| Tool fro entering data in subsequent cells | Excel Discussion (Misc queries) | |||
| Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
| Dates in 2005 format cells are not entering correctly. | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
