Excel 2000 date formats

  • Thread starter Thread starter Chris Russell
  • Start date Start date
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
 
Hi Chris!

It sounds like these dates are not dates but are text.
 
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'
 
You must log in or register to reply here.

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

Excel 2002: How to make the date format uniform ? 1
Date Formats 1
date 1
Date format changes in mail merge using Excel worksheet as data 2
Date automatically swaps 6
Formatting Dates from Text to Numbers 2
Excel - convert dates to text but appear as a date format 6
counting records by month and year / date format issues 1

Back
Top