OMG!! How do i change a date from yyymmdd to show as mm/dd/yyyy?
S steve_doc Jun 20, 2007 #2 Select cells to format Format/Cells/Number Tab/Date -1st date format on the list Disclamer - may differ depending on regional settings
Select cells to format Format/Cells/Number Tab/Date -1st date format on the list Disclamer - may differ depending on regional settings
P Peo Sjoblom Jun 20, 2007 #3 Select the column with the "dates", do data>text to columns, click next twice, under column data format select date and YMD, click finish
Select the column with the "dates", do data>text to columns, click next twice, under column data format select date and YMD, click finish
