Try DATEVALUE to convert a text date to numeric.

jer101 < wrote:

JWOLF...

Perhaps I did not explain my problem clearly in the earlier version...
(and I am not sure I will be any better this time) but of the dates I
was comparing one was showing in a text format in both the cell and the
edit bar. The other was only showing in the text format in the cell.
Excel will not allow you to change a text version of a date to a
numeric value using the format feature; so I had to change the numeric
value using John's solution.

I know I am new at this... but you guys are really helpful, I love this
site...

Ed Robinson


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