Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to suppress leading zeros in Excel
I recieve a spreadsheet that has phone stored as a 10 digit number. I need
to parse it to end up with 3 columns; AreaCode, Exchange, Extension. I use Text to Columns to split this. The problem I have is that leading zeros are suppressed. For example if an extension is 0040 the leading zeros are suppressed and it is displayed as 40. How can I make sure it is always displayed as a 4 digit number? |
#2
|
|||
|
|||
FormatCellsNumber tab, Custom. In the Type box, enter 0000
-- Kind regards, Niek Otten Microsoft MVP - Excel "Jay" wrote in message ... I recieve a spreadsheet that has phone stored as a 10 digit number. I need to parse it to end up with 3 columns; AreaCode, Exchange, Extension. I use Text to Columns to split this. The problem I have is that leading zeros are suppressed. For example if an extension is 0040 the leading zeros are suppressed and it is displayed as 40. How can I make sure it is always displayed as a 4 digit number? |
#3
|
|||
|
|||
Make the format of the field Text instead of General (when you do your data|Text
to columns). Jay wrote: I recieve a spreadsheet that has phone stored as a 10 digit number. I need to parse it to end up with 3 columns; AreaCode, Exchange, Extension. I use Text to Columns to split this. The problem I have is that leading zeros are suppressed. For example if an extension is 0040 the leading zeros are suppressed and it is displayed as 40. How can I make sure it is always displayed as a 4 digit number? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Leading Zeros and decimal points | Excel Worksheet Functions | |||
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) |