leading zeroes disappear from phone #

  • Thread starter Thread starter caroljm36
  • Start date Start date
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?
 
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
 
My VBA level is very superficial ... perhaps someone out there can take
over from here.

Regards.
 
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"
 
Back
Top