Converting dates to different formats
Wow that was easy! I hadn't even thought of changing the format of the
column! Thanks to all for your help.
"Gary''s Student" wrote:
There are two cases:
1. if the data is a genuine Excel date/time, then just format the cell to:
Custom mm/dd/yyyy
2. if the data is only a text string then use the formula:
=LEFT(A1,LEN(A1)-FIND(" ",A1)-2)
--
Gary''s Student - gsnu200902
"Nelson B." wrote:
I get an exported file with the date and time column as follows:
6/12/2009 9:01:00 AM (all in one cell)
Is there a way to convert this to just 6/12/2009?
Also how would you convert to just the month?
Thanks!
|