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

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