| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a leading zero in a number field, (i.e. 0301234)?
I have numbers that need to be added to my spreadsheet that contain a leading
zero, same as the subject. It is part of the number, some also have 1s or 2s so the zero is an imporatant part of the number. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a leading zero in a number field, (i.e. 0301234)?
Jim Clay wrote:
I have numbers that need to be added to my spreadsheet that contain a leading zero, same as the subject. It is part of the number, some also have 1s or 2s so the zero is an imporatant part of the number. Jim, If your number is NOT calculated, i.e. a part number, then format the cells as text. If it IS calculated and you have a standard length (say 8 places), then format/special/00000000 k? Beege |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a leading zero in a number field, (i.e. 0301234)?
Assuming that all the numbers contain the same number of digits (say, 7 in
your example), set the cell number format to 0000000 (via the Format - Cells - Number - Custom option). Any numbers entered upto 7 digits in length will be padded with leading zeros to make it 7 digits long. "Jim Clay" wrote: I have numbers that need to be added to my spreadsheet that contain a leading zero, same as the subject. It is part of the number, some also have 1s or 2s so the zero is an imporatant part of the number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table row fields limit vs. number of rows in use for Excel 2 | Excel Discussion (Misc queries) | |||
| number changing digits on paste from web apx file field | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
| single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions | |||
Linear Mode
