Did you already have the digits entered in the one cell when you formatted
to text?

Rob

"TJS" wrote in message
...

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