On Mar 5, 12:25*pm, Dave Peterson wrote:
This worked for me with my Windows USA date settings (mdy order):

Select the range to fix:
Edit|replace
what: _* *(spacebar followed by an asterisk)
with: (leave blank)
replace all

And format the range to show only the date (mm/dd/yyyy for example).

Rob wrote:

How do I remove the time from a date field ? *In Excel, the date is displayed
as follows : *10/30/2007 *2:34:24 PM

I need to remove the time from this value. *I have tried to format the cell
with the proper date format (ie - mm/dd/yyyy) but the time still remained.

Any help would be GREATLY appreciated.

Thanks!
Rob

--

Dave Peterson

Also you can just use this formula: =DATEVALUE(LEFT(A1,10)) and format
the cell as date.