How do I change date format without losing data?

S

ScottNovo

I have a an Excel worksheet that has about 3,500 birthdates entered. The
format is if the person was born on january1st of 1960, it would look like
this: 19600101.
The program I use to calculate my work needs these formatted in the
traditional 01/01/1960. How do I get the whole column to change that format?
I really do not want to retype the whole thing.


PS -- The cell format is number, (-1234) according to Excel...
 
J

JE McGimpsey

Select the column. Choose Data/Text to Columns. Click Next, Next, then
select the YMD item in the Date dropdown (assuming that your current
format is YYYYMMDD - your example is ambiguous). Click Finish.
 
S

ScottNovo

Absolutely phenomenal! Thanks for your help. You have no idea how much time
and frustration you saved me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top