| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a 0 to a four digit number
I have 4000+ zipcodes in a .csv file that I have imported to excel. The .csv file shows all zipcodes that start with 0 as a for digit number instead of 5. I need to add the 0 infront of the four that show up. for example 19601 fills in correctly 08054 shows as 8054 I need an if then statement that basically says if 4 digits then add a 0 infront is 5 digits remain the same. -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=500920 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding number only if CDN is displayed in next cell | New Users to Excel | |||
| How do I copy the last digit of a number from a cell | Excel Discussion (Misc queries) | |||
| Entering a 16 digit number | Excel Discussion (Misc queries) | |||
| How do i format a 5 to 6 digit number into the correct date? | Excel Worksheet Functions | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
Threaded Mode
