On Mon, 7 Feb 2005 08:59:07 -0800, berryware421243
wrote:

Hello,

We have a web based asset tracking system, and some assets have long serial
numbers; for instance,
3100600300030147987
or
3101600300100020220

When we import, cut and paste, or open an HTML format page in Excel with
these serial numbers, they all show up as: 3.1016E+18 and the last 6 digits
get rounded up.

How do we show the correct value for these long numbers in excel?

Thanks


These must be imported as TEXT.


--ron