I have a coulmn with numbers, but they are formatted as text.


ESN #s
268435456106743252

But when I format it to numbers, I get the following error:

2.68435E+17

This also creates a problem since this process also zeros out the last
three digits:

268435456106743000 (the 252 are now replaced as 000)

Does anyone know way to correct this?

Thanks in advance!




--
moyemrick