How are you putting the date in the cell?
If the date is a result of a formula, is it negative? Negative dates
show up as #'s
Have you tried to autofit the columns?


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=543580