adding a leading 0 to only the numbers with 4 digits

's Computer Specifications

I'm converting a bunch of data and during the import Excel dropped the
leading zero from all the lip codes. Since this is about 15,000
records, I'd like a way to add a leading zero to only the zip codes
with 4 characters. Any ideas?
thanks

's Computer Specifications

Swamp,

Format/Cells/Special/Zip Code

Beege

"SwampYankee" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm converting a bunch of data and during the import Excel dropped the
> leading zero from all the lip codes. Since this is about 15,000
> records, I'd like a way to add a leading zero to only the zip codes
> with 4 characters. Any ideas?
> thanks
>

's Computer Specifications

There is a zip code format under format>cells>number

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

"SwampYankee" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm converting a bunch of data and during the import Excel dropped the
> leading zero from all the lip codes. Since this is about 15,000
> records, I'd like a way to add a leading zero to only the zip codes
> with 4 characters. Any ideas?
> thanks
>

's Computer Specifications

In article <(E-Mail Removed)>,
(E-Mail Removed) says...
> I'm converting a bunch of data and during the import Excel dropped the
> leading zero from all the lip codes. Since this is about 15,000
> records, I'd like a way to add a leading zero to only the zip codes
> with 4 characters. Any ideas?
> thanks
>
>
Dohhhh!!..........Thanks, should have known that, thanks

's Computer Specifications

I know this is way after the fact, but for the archive...

Alternatively (if it were not zip codes but some other similar
situation), you can use the "text" function. Assuming your data begins
in A1, in cell B1 type: =TEXT(A1,"00000"). Copy down to the end of your
data. Then highlight the data in column B and copy/paste special/values
back into column A. This will work for any number of characters, just
change the number of zeros in the formula.

S

SwampYankee wrote:
> I'm converting a bunch of data and during the import Excel dropped the
> leading zero from all the lip codes. Since this is about 15,000
> records, I'd like a way to add a leading zero to only the zip codes
> with 4 characters. Any ideas?
> thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
4-5 digit numbers to display leading zeros totalling 6 digits	Professor_Higgins	Microsoft Excel Programming	2	7th Aug 2008 12:11 AM
Adding "0" as leading digits into cells in Excel	=?Utf-8?B?VGlwcGV0dWU=?=	Microsoft Excel Worksheet Functions	2	19th Oct 2006 01:14 AM
adding digits to front/end of fax numbers	=?Utf-8?B?THVrZQ==?=	Microsoft Excel Misc	2	28th Apr 2005 12:35 AM
Convert 8 digits to leading alpha plus 6 digits following?	Lee Jeffery	Microsoft Excel New Users	0	21st Sep 2004 09:33 AM
Convert 8 digits to leading alpha plus 6 digits following?	Lee Jeffery	Microsoft Excel New Users	1	21st Sep 2004 05:25 AM