preface the 268435456106743252 with a ' or retain the format as text.

You can't format as "number" as Excel only supports 15 significant digits.

moyemrick wrote:

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!