When I have the situation like yours I usually use the apostraphe '
before the number. This tells Excel to format the cell as text and not
numbers. The ' doesnt show when you enter it by hand. It does show if
you are copying data from another source. All you need to do is click
on the edit line of each of the cells that are showing and hit enter,
it then disappears.


--
shane24
------------------------------------------------------------------------
shane24's Profile: http://www.excelforum.com/member.php...fo&userid=4770
View this thread: http://www.excelforum.com/showthread...hreadid=490077