Have you tried using the text function - text(cell,"d-mmm-
yyyy")?

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

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




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

.