| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I keep zeros in the beginning of a number in excel
Everytime I type in a number that starts with zeros in an excel cell - excel
automatically drops the zeros from the number how can I format the cell to keep the zero? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I keep zeros in the beginning of a number in excel
To enter it as text, either precede the entry with an apostrophe or preformat
the col as Text. If you want it retained as numbers but to display the leading zeros in the cells, preformat the col as custom, type: 0000 (for example) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Starprincess" wrote: Everytime I type in a number that starts with zeros in an excel cell - excel automatically drops the zeros from the number how can I format the cell to keep the zero? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I keep zeros in the beginning of a number in excel
On the Menu Bar, click Format, Cells, Number, and choose Custom -- enter
0000 in the field titled "Type" HTH "Starprincess" wrote in message ... Everytime I type in a number that starts with zeros in an excel cell - excel automatically drops the zeros from the number how can I format the cell to keep the zero? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How come Word is adding zeros to a mail merge number from Excel? | Excel Worksheet Functions | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
| Excel not taking number format consistently | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
