Do you know how to save this column of birth dates in format mm/dd/yyyy from this Excel 2003 file?

zimmer9
zimmer9 used Ask the Experts™
on
Do you know how to save this column of birth dates in format mm/dd/yyyy from this Excel 2003 file?
MS.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
here you go
Copy-of-MS.xls
convert to number and then format as date
NorieAnalyst Assistant

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial