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