leading zeroes disappear from phone #

C

caroljm36

I got an export with voter registration data, with 3 separate fields for
area code, first 3 digits and last 4 digits. In the last column, if a
number begins with 0 it just disappears, so you have a number that
looks like 406 728 889. It's very confusing to our volunteers.

Is there any way to format the cells so the zeroes are displayed? I
know I can comment them out individually but is there any way to do it
globally without overwriting the number?
 
B

BenjieLop

caroljm36 said:
I got an export with voter registration data, with 3 separate fields fo
area code, first 3 digits and last 4 digits. In the last column, if
number begins with 0 it just disappears, so you have a number tha
looks like 406 728 889. It's very confusing to our volunteers.

Is there any way to format the cells so the zeroes are displayed?
know I can comment them out individually but is there any way to do i
globally without overwriting the number?
Click to expand...

Formatting the cells to "Text" will take care of this hopefully.

Regards
 
B

BenjieLop

My VBA level is very superficial ... perhaps someone out there can take
over from here.

Regards.
 
D

Dave Peterson

You could just give the 3 digit columns a custom format of: 000
(Format|cells|number tab|custom)

And the 4 digit column would have a custom format of: 0000

If you're looking for code, you record a macro when you do it manually.

It would look something like:

activesheet.range("a:a").numberformat="000"
 
Top