Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
leading zeros in excel
I need to display leading zeros in whole numbers eg 05324
|
#2
|
|||
|
|||
Format as 00000
-- HTH Bob Phillips "kiwi" wrote in message ... I need to display leading zeros in whole numbers eg 05324 |
#3
|
|||
|
|||
If that is for a US zip code, they really should be
formatted as text then they can also be consistent with zip+4 codes as well, and with codes used in other countries as well. Format as text is best, or precede with a single quote. If they aren't going to be treated arithmetically then they probably should not be treated as numbers. Credit cards for instance are usually 16 digits and Excel only provides for 15 digits so they have to be entered as text or you end up with bad data. "Bob Phillips" wrote in message ... Format as 00000 -- HTH Bob Phillips "kiwi" wrote in message ... I need to display leading zeros in whole numbers eg 05324 |
#4
|
|||
|
|||
You can also format the cell as 'TEXT' and display leading zeros.
Don 1 "kiwi" wrote: I need to display leading zeros in whole numbers eg 05324 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I WANT to truncate my leading zeros | Excel Discussion (Misc queries) | |||
In Excel how can i enter in a value like 0021 without the zeros . | Excel Discussion (Misc queries) | |||
How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel | |||
numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) |