I have to perform a comparison with dates and I am having a problem wit
the format... I hope somebody can help me. Here's the proble
specifics...

The date format shows in the spreadsheet cell as 1-Jul-2003 but it i
really 7/1/2003 when I look up top. I need to know how to get conver
the 7/1/2003 to 1-Jul-2003 as a text format, if that is possible. The
I will be able to compare it to the date in my other spreadsheet whic
is in a text format.

:confused

--
Message posted from http://www.ExcelForum.com