Format a number to be a date

  • Thread starter Thread starter Efficient
  • Start date Start date
E

Efficient

I need to re-format a column of numbers that is formated as six digi
number to become reformated as dates. For example, one cell contain
the number 070403 represents the date July 4, 2003.

How can I reformat the number in this cell to become mmddyy
 
Hi
try in an adjacent column the following formula
=DATE("20" & RIGHT(A1,2),LEFT(A1,2),MID(a1,3,2))
 
Data>Text to Columns>Fixed Width>Next>Next>"Date" and choose a format then
"Finish"

Gord Dibben Excel MVP
 
Back
Top