Hi there,

Frustratingly when I copy from a website with a big table of data that some
of the columns contain variously formatted international telephone numbers,
and then paste this data into Excel, all the long telephone numbers come out
as numerical values.

For example
4454344348579544
comes out as:

4.454345+11

Even when I prepare the cells to be formatted as Text, this is still
ignored. I have tried paste special, but I only get the option of Text, HTML
and Unicode and none give the desired result.

Can anyone help me finally resolve this frustrating problem.

Kind regards

Dave