Converting dates to different formats
Well€¦.
Considering the data is in single column and same format always with same
spacing€¦.
Process: Select the number of cells or data in couln and Go to Data in Menu
Bar--- Text to Columns---- Fixed width---- next--- check that the line
appears after the date and before the time---- Next ----- Date column should
be highlighted---- Go to Column data Format---- Select date and format(MDY or
DMY and so on) you wish to have------ now select the 2nd column besides
date--- go to column format--- select do not import column i.e. skip ------
and repeat the same for the 3rd column if any----- Now click finish---- you
should have what you want€¦€¦
If the dat is in not in same spacing than use delimited format instead of
Fixed width and click space for separator and uncheck everything else€¦. And
follow almost the same procdure€¦
Hope that is what you want€¦
If it helps€¦. Please click yes below€¦..
"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!
|