Need help converting date time to date only

[Genga]

I have a column in my spreadsheet with date and time, you can see in m
attachment. I want to convert this column in to date only. Pleas
help.

Thanks
Geng

Attachment filename: sales - open orders test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=57210

 

[Frank Kabel]

Hi
without looking at your file you could use the following formula in a
helper column
=INT(A1)
and format this cell as 'date'

 

[UncleBob]

Or, if you need it as a text field,
=text(a1,"mm/dd/yy") . Lots of flexibility in the
format.
message

Hi
without looking at your file you could use the following formula in a
helper column
=INT(A1)
and format this cell as 'date'

http://www.excelforum.com/attachment.php?postid=572108 -
--