| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel find 5 digit number and replace with leading zero
I have a column of 5 digit numbers which I would like to replace with the
same number with a leading zero. -- CDP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel find 5 digit number and replace with leading zero
Hi,
Apply a custom format of 000000 that's 6 zeroes Mike "CDPalmer" wrote: I have a column of 5 digit numbers which I would like to replace with the same number with a leading zero. -- CDP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel find 5 digit number and replace with leading zero
If you want to *display* the leading zero, use a custom format of 000000
(that's 6 zeros) If you want the leading zero stored in the spreadsheet, convert your numbers to text using: =text(a1,"000000") Regards, Fred. "CDPalmer" wrote in message ... I have a column of 5 digit numbers which I would like to replace with the same number with a leading zero. -- CDP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need 7 digit number with differnt number of leading zeros | Excel Discussion (Misc queries) | |||
| find & replace - digit wildcard | Excel Discussion (Misc queries) | |||
| Find 1 word and replace it and leave the leading zero | Excel Discussion (Misc queries) | |||
| How to add leading 0 to four digit number? | Excel Worksheet Functions | |||
| single quote 10-digit number that has leading zeroes & then conca. | Excel Worksheet Functions | |||
Hybrid Mode
