| 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... |
| 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 | |||
Threaded Mode
