Excel 2000 date formats

C

Chris Russell

A spreadsheet of information I have downloaded for
importing into a new database application has dates of
birth in United States format mm/dd/yyyy (ie 03/27/1945
for March 27 1945).

How can I change these dates to to dd/mm/yyyy? I've tried
Format Cells Number Date, but no option for dd/mm/yyyy
shows up as a choice. Going to Format Cells Number Custom,
selecting dd/mm/yyyy and OK does not bring about a change
in the format displayed by the cell. In other words, it
still shows up as mm/dd/yyyy. What am I missing here?
Please help.

Regards,

Chris Russell
 
F

Frank Kabel

Hi
as Norman pointed out these dates are probably stored as 'Text' to
convert them to real numbers try the following:
- select an empty cell and copy this cell
- select your range of dates
- goto 'Edit - Paste Special' and choose 'Add'
 

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

Similar Threads

Date Formats 1
Excel 2002: How to make the date format uniform ? 1
Date format changes in mail merge using Excel worksheet as data 2
Changing date to eliminate day in format mm/dd/yyyy 1
Excel - convert dates to text but appear as a date format 6
counting records by month and year / date format issues 1
Date Formatting Error 1
Date Formatting in Excel Urgent 1

Top