leading zeroes disappear from phone #

[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?

[BenjieLop]

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?

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

Regards.

[bach]

How do you go about achieving this in VBA??

BAch

[BenjieLop]

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

Regards.

[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"



caroljm36 wrote:
>
> 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
> ------------------------------------------------------------------------
> caroljm36's Profile: http://www.excelforum.com/member.php...o&userid=19046
> View this thread: http://www.excelforum.com/showthread...hreadid=471130

--

Dave Peterson

[bach]

Thanks for your help.