zimmer9
asked on
Do you know how to save this column of birth dates in format mm/dd/yyyy from this Excel 2003 file?
Do you know how to save this column of birth dates in format mm/dd/yyyy from this Excel 2003 file?
MS.xls
MS.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are these definitely dates?
Not sure what you mean about saving, but if you want to convert dates you can try this.
1 Select a blank cell in the worksheet.
2 Copy the blank cell.
3 Select the 'dates'.
4 Goto Paste>Paste Special... and select Add from the operation section.
5 With the dates still selected goto Format and chose your date format.
Not sure what you mean about saving, but if you want to convert dates you can try this.
1 Select a blank cell in the worksheet.
2 Copy the blank cell.
3 Select the 'dates'.
4 Goto Paste>Paste Special... and select Add from the operation section.
5 With the dates still selected goto Format and chose your date format.
Copy-of-MS.xls