how do I convert date format yyyymmdd to mm/dd/yyyy
If it's a column of cells...
Select the column
Data|text to columns (in xl2003 menus)
choose fixed width, but don't have any delimiter lines
Choose Date (ymd)
This will convert the data to dates.
Now you can format the ranyge the way you like.
Datahead wrote:
how do I convert date format yyyymmdd to mmddyyy
I have rows of dates displayed as yyyymmdd (ie 20100131)
I want them displayed as regular dates (ie 01/31/2010)
--
Dave Peterson
|