Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change date format without losing data?
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... |
#2
|
|||
|
|||
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. In article , ScottNovo wrote: 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. |
#3
|
|||
|
|||
Absolutely phenomenal! Thanks for your help. You have no idea how much time
and frustration you saved me. "JE McGimpsey" wrote: 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. In article , ScottNovo wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Format Data Series Markers | Charts and Charting in Excel | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |