00E0159 displays as 0.00E+00 when pasted into an excel

[rscosworth]

Good Morning,

First time query on the forum so hope you will be able to explain to me why I am having this problem and how to workaround it.

I have a table of data which I copy from an internal website. The value contained in the field is 00E0159 but no matter how I paste it into excel it displays 0.00E+00 and changes the formatting to scientific.

I have tried, get external data (from web), paste keep, paste match, paste special (html, unicode and text). I have tried exporting the webpage to PDF and then importing into excel but every time it changes the number formatting.

Anyone able to help with my query?

Thanks and Merry Christmas

[Special-K]

As is fairly obvious Excel's interpreting the text as a number.
e.g.
100 = 1E2 so
00E0159 is interpeted as zero to 159 decimal places.

Some info/solutions here

http://support.microsoft.com/kb/214233

[Glenn Kennedy]

Preformat the column as text and then paste it in.

[rscosworth]

Thank you both very much - problem sorted in 10minutes - Merry Christmas

[Glenn Kennedy]

You're welcome & Happy Xmas to you & yours...