If you formatted the cell after you did the data entry, it's too late.

If you formatted that cell before you did the data entry, then try formatting it
once more--I'm betting that you made a minor mistake (maybe hit cancel instead
of ok???).

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,
>
> --
> TJS
> ------------------------------------------------------------------------
> TJS's Profile: http://www.excelforum.com/member.php...o&userid=29583
> View this thread: http://www.excelforum.com/showthread...hreadid=494277

--

Dave Peterson