I cannot reproduce the behaviour that I understand you to be describing
here. What version of Excel? What steps exactly?

Prefixing with an apostrophe is always reliable.

Jerry

TJS wrote:

> OK That'sf what I did, with a little twist though...
>
> When I format just 1 cell to text, it did the same 15 digits thing.
> When I format the whole column to text, it finally displayed right.
> What gives?
>
> Thanks,