OMG!! How do i change a date from yyymmdd to show as mm/dd/yyyy?

Select cells to format

Format/Cells/Number Tab/Date -1st date format on the list

Disclamer - may differ depending on regional settings

"Kelli" wrote:

OMG!! How do i change a date from yyymmdd to show as mm/dd/yyyy?

Select the column with the "dates", do datatext to columns, click next
twice, under column data format select date and YMD, click finish


--
Regards,

Peo Sjoblom



"Kelli" wrote in message
...
OMG!! How do i change a date from yyymmdd to show as mm/dd/yyyy?