change the century

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have pulled into Excel a lot of information from a database, unfortunately
the database has only 2 characters for the year in a date field do people are
having their dates of birth set as 24th June 2047

How can I correct this in Excel?
 
How is the cell formatted? When I enter 6/24/47, I get June 24, 1947 returned.

Dave
 
When I input a date manually is is correct but when it is pulled in from a
database using a Query it's wrong.
 
Can you modify the query to spell out the full four digit year? What is the
SQL you're using?

Dave
 
It's probably because it is seen as text, what happens if you format a cell
with those dates as general?
If it is a number it should return 53867

Regards,

Peo Sjoblom
 
Keith

Might help if you go into Regional Settings in Control Panel and change the
ending year for the century under Customize>Date "Interpret 2-digit years as
between"

Maybe back to 2030 or similar. Windows default is 2029.


Gord Dibben MS Excel MVP
 
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

Problem with sorting 19th century dates 2
Date formula rounded up 2
Calculating age from date of birth and ignoring if blank 5
Access Access, problem with query. 5
create calculated field for age in pivot tables 4
How do I format dates to accomodate birth years prior to 1930? 4
How to set up a devilery schedule calendar from excel database 2
Excel Using templates from email in Excel 0

Back
Top