Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a field in Excel to allow for leading zeros?
I am creating an Excel Document that has certain values that must have
leading zeros. Does anyone know how to allow leading zeros in Excel? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a field in Excel to allow for leading zeros?
You have a few options.
If you want to treat the value as text: #1. Preformat the cell as Text (format|cells|Number tab|Text) (then do the data entry) #2. Prefix your entry with an apostrophe: '0012345 If you want to treat the value as a number: #1. Give the cell a custom format like: Format|cells|number tab|Custom category|000000 (to show 6 digits--including leading digits if required) debbie wrote: I am creating an Excel Document that has certain values that must have leading zeros. Does anyone know how to allow leading zeros in Excel? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a field in Excel to allow for leading zeros?
Use a number format like 0000, with one zero per digit. For example, a zip
code requires a number format of 00000 or 00000-0000. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "debbie" wrote in message ... I am creating an Excel Document that has certain values that must have leading zeros. Does anyone know how to allow leading zeros in Excel? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a field in Excel to allow for leading zeros?
You can either use a custom NUMBER format if the length of all entries will
be the same. For example: Custom format 00000 Then: 1 becomes 00001 12 becomes 00012 123 becomes 00123 1234 becomes 01234 12345 stays 12345 However, using this method Excel will still not recognize the leading 0's. 00001 has a true underlying value of 1. Or, you can preformat the cells as TEXT. Or, you can precede the entry with an apostrophe as you enter them: '00001. This also results in a TEXT entry. Biff "debbie" wrote in message ... I am creating an Excel Document that has certain values that must have leading zeros. Does anyone know how to allow leading zeros in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading zeros in text format | Excel Discussion (Misc queries) | |||
How do I keep leading zeros and format my cells as text? | Excel Discussion (Misc queries) | |||
hyphenated number format with leading zeros to the right of the hy | Excel Discussion (Misc queries) | |||
Format a cell to keep leading zeros. | New Users to Excel | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |