When I paste a list of telephone numbers, any leading
zeros are not displayed. (eg. 0944.. shows as 944...) How
can I display them corectly?

Thanks
Andy

"Andy" <(E-Mail Removed)> wrote in message
news:08a701c3da94$2dd89710$(E-Mail Removed)...
> When I paste a list of telephone numbers, any leading
> zeros are not displayed. (eg. 0944.. shows as 944...) How
> can I display them corectly?
>
> Thanks
> Andy

Format the cells as text before pasting the data.

>-----Original Message-----
>"Andy" <(E-Mail Removed)> wrote in
message
>news:08a701c3da94$2dd89710$(E-Mail Removed)...
>> When I paste a list of telephone numbers, any leading
>> zeros are not displayed. (eg. 0944.. shows as 944...)
How
>> can I display them corectly?
>>
>> Thanks
>> Andy
>
>Format the cells as text before pasting the data.
>

Hi Paul
Unfortunately it doesn't work since the original data is
in html format and when pasting, Excel defaults back to
number format. If I change the format back to text after
pasting, then the zeros are 'lost'. If I choose "paste
special" and paste as text, then all the data is pasted to
one column.
Andy

and to fix your existing numbers to convert them to text
with a macro
you might take a look at FixUSzip5 and adapt that
to your flavor of telephone numbers (if they are consistent)
http://www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5

If you can't adapt that macro yourself you would have to specify
what the actual phone numbers look like and how they are
formatted under Format, cells, number, custom

Instructions to install and use a macro on my getstarted.htm page.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Paul" <none> wrote in message news:(E-Mail Removed)...
> "Andy" <(E-Mail Removed)> wrote in message
> news:08a701c3da94$2dd89710$(E-Mail Removed)...
> > When I paste a list of telephone numbers, any leading
> > zeros are not displayed. (eg. 0944.. shows as 944...) How
> > can I display them corectly?
> >
> > Thanks
> > Andy
>
> Format the cells as text before pasting the data.
>
>

If I copy and paste from HTML, I will get text entries for
"numbers" beginning with zero as Text without the zeros
being stripped off. So it would seem that the HTML that your
are reading from was generated from an Excel spreadsheet
and that they were numbers in the original Excel worksheets
-- in other words you have "round tripping" code in your HTML.

What I posted before still applies. I did not realize that 4 digits
was the entire phone number. You can use a custom format
of 0000 and you could then use the code I mentioned before
changing 5 to 4 and 00000 to 0000
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

<(E-Mail Removed)> wrote in message news:0a3c01c3da97$84abe300$(E-Mail Removed)...
>
> >-----Original Message-----
> >"Andy" <(E-Mail Removed)> wrote in
> message
> >news:08a701c3da94$2dd89710$(E-Mail Removed)...
> >> When I paste a list of telephone numbers, any leading
> >> zeros are not displayed. (eg. 0944.. shows as 944...)
> How
> >> can I display them corectly?
> >>
> >> Thanks
> >> Andy
> >
> >Format the cells as text before pasting the data.
> >
>
> Hi Paul
> Unfortunately it doesn't work since the original data is
> in html format and when pasting, Excel defaults back to
> number format. If I change the format back to text after
> pasting, then the zeros are 'lost'. If I choose "paste
> special" and paste as text, then all the data is pasted to
> one column.
> Andy

"Andy" <(E-Mail Removed)> wrote in message
news:08a701c3da94$2dd89710$(E-Mail Removed)...
> When I paste a list of telephone numbers, any leading
> zeros are not displayed. (eg. 0944.. shows as 944...) How
> can I display them corectly?
>
> Thanks
> Andy

Another suggestion...

I copied my phone number from my website, which is in HTML, and pasted it
into Excel.
The numbers displayed as a phone number with all zeros in place.
My cell formatting isn't text; it's "general".

Also, if you want a quick way to strip away HTML, or any formatting for that
matter, copy
the material in question, then paste it into notepad. The formatting won't
be included with
the text or phone number.

First, though, I'd make sure your cell format is "general". Newer versions
of Office know how
to play well with HTML.

Feedback would be cool...

Best Regards,
bob

He didn't have HTML formatting if he pasted and got numbers.
but that technique may still be of use for his problem.

Another technique to get rid of leading and trailing spaces
after converting the non breaking space character (&nbsp
to spaces is TrimALL in
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"bob @cssalert.com>" <expert> wrote in message news:W3bNb.47957$Rc4.198575@attbi_s54...
>
> "Andy" <(E-Mail Removed)> wrote in message
> news:08a701c3da94$2dd89710$(E-Mail Removed)...
> > When I paste a list of telephone numbers, any leading
> > zeros are not displayed. (eg. 0944.. shows as 944...) How
> > can I display them corectly?
> >
> > Thanks
> > Andy
>
> Another suggestion...
>
> I copied my phone number from my website, which is in HTML, and pasted it
> into Excel.
> The numbers displayed as a phone number with all zeros in place.
> My cell formatting isn't text; it's "general".
>
> Also, if you want a quick way to strip away HTML, or any formatting for that
> matter, copy
> the material in question, then paste it into notepad. The formatting won't
> be included with
> the text or phone number.
>
> First, though, I'd make sure your cell format is "general". Newer versions
> of Office know how
> to play well with HTML.
>
> Feedback would be cool...
>
> Best Regards,
> bob
>
>