Thanks. I couldn't figure out how to get it to work for my speadsheet,
because I needed the values to be in mm/dd/yy format. However, I also
figured out that I could do it by going to Tools-Options-View, and
deselect the zero values box. Thanks a lot!!!!


--
Dahaynes
------------------------------------------------------------------------
Dahaynes's Profile: http://www.excelforum.com/member.php...o&userid=28276
View this thread: http://www.excelforum.com/showthread...hreadid=477384