Hi

I run Excel 2K

I download info from the mainframe into a workbook.

This information contains a date for each entry.

This is the format that the "date" is downloaded in (29:53.0)....when the
curser is placed on this example it displays it as 31/07/2009 12:29:53 AM in
the "edit bar" of the spreadsheet.

I can then format the (29:53.0) to dd/mmm/yy which then reads 31/Jul/09.

However in the edit bar still shows it as 31/07/2009 12:29:53 AM.

I need to be able to format it so that in the edit bar it only shows the
dd/mmm/yy and not have the time format attched to it.

The reason I need this to happen is that I have a formula that looks at this
date and if it is greater than or equal to the date it displays a TRUE or
FALSE.

The "time" at the end is what is mucking it up as when I just put a date in
manually the formula works fine. I have used this formula in many worksheets
before so I know it works ok.

By the way the formula is =AND(D3=Start_Date,D3<=End_Date)

Anyway, what I need is a way to format this date so that it does not include
the time component or a formula that removes it.


Thanks


John