S
Sillysamiam
Can I change 19840822 to read August 22, 1984 ??
Not just one time, but a whole column of 1000 names and birth dates.
Not just one time, but a whole column of 1000 names and birth dates.
F
Frank Kabel
Hi
try the following
- select your cells
- goto 'Data - Text to columns'
- in the wizard choose 'Date' as filed type and select the correct date
format
- finish the wizard
Prior to this make a backup of your data
try the following
- select your cells
- goto 'Data - Text to columns'
- in the wizard choose 'Date' as filed type and select the correct date
format
- finish the wizard
Prior to this make a backup of your data
N
Norman Harker
Hi Sillysamiam!
You can use:
=DATE(A1/10000,MID(A1,5,2),RIGHT(A1,2))
Or use Data > Text to Columns
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
You can use:
=DATE(A1/10000,MID(A1,5,2),RIGHT(A1,2))
Or use Data > Text to Columns
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.