ExcelBanter - How do I convert a number like 19660124 to 01-24-1966 in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I convert a number like 19660124 to 01-24-1966 in excel? (https://www.excelbanter.com/excel-worksheet-functions/134069-how-do-i-convert-number-like-19660124-01-24-1966-excel.html)

Katyfarm

How do I convert a number like 19660124 to 01-24-1966 in excel?

I have a lengthy column in Excel of birthdates, written as 19660124 and I
need to convert them so they read like 01-24-1966.

Thanks!

Ron Rosenfeld

How do I convert a number like 19660124 to 01-24-1966 in excel?

On Thu, 8 Mar 2007 14:27:00 -0800, Katyfarm
wrote:

I have a lengthy column in Excel of birthdates, written as 19660124 and I
need to convert them so they read like 01-24-1966.

Thanks!

Select the column, then:

Data/Text to Columns
Next
Next
Column Data Format/Date/YMD
Finish

Format/Cells/Number Custom Type: mm-dd-yyyy
--ron

Katyfarm

How do I convert a number like 19660124 to 01-24-1966 in excel

Thank you SO much, Ron!! That worked like a charm!
:-) Stephanie

"Ron Rosenfeld" wrote:

On Thu, 8 Mar 2007 14:27:00 -0800, Katyfarm
wrote:

I have a lengthy column in Excel of birthdates, written as 19660124 and I
need to convert them so they read like 01-24-1966.

Thanks!

Select the column, then:

Data/Text to Columns
Next
Next
Column Data Format/Date/YMD
Finish

Format/Cells/Number Custom Type: mm-dd-yyyy
--ron

All times are GMT +1. The time now is 10:36 PM.