zeros that begin in zip codes

[biglb79]

if I have a huge list of zip codes and need the one or two zeros to appear as text format, is there an easy way to add them as opposed to going down the list manually and keying: '0 or '00?

thanks

 

[Joe4]

Assuming you are working with 5 digit zip codes, if you just want them to appear that way, you can simply use a Custom Number Format of "00000".
If you physically need to value to change, you can use a formula like:

=REPT("0",5-LEN(A1)) & A1

to add the zeroes.

You can do a Copy -> Paste Special -> Values if you then want to change that formula to hard-coded values.

 

[biglb79]

nice thanks!

 

[Joe4]

You are welcome!

 

[Rick Rothstein]

If you physically need to value to change, you can use a formula like:

=REPT("0",5-LEN(A1)) & A1

to add the zeroes.

Just pointing out that alternately, you could also use this formula...

=TEXT(A1,"00000")

 

[Joe4]

Just pointing out that alternately, you could also use this formula...

=TEXT(A1,"00000")

D'oh!

Cannot believe I overlooked the obvious!
Must have had a brain cramp!