change the century
 

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?

change the century
 

How is the cell formatted? When I enter 6/24/47, I get June 24, 1947 returned.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Keith" wrote:

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?

change the century
 

When I input a date manually is is correct but when it is pulled in from a
database using a Query it's wrong.

"Dave F" wrote:

How is the cell formatted? When I enter 6/24/47, I get June 24, 1947 returned.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Keith" wrote:

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?

change the century
 

Can you modify the query to spell out the full four digit year? What is the
SQL you're using?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Keith" wrote:

When I input a date manually is is correct but when it is pulled in from a
database using a Query it's wrong.

"Dave F" wrote:

How is the cell formatted? When I enter 6/24/47, I get June 24, 1947 returned.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Keith" wrote:

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?

change the century
 

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" wrote in message
...
When I input a date manually is is correct but when it is pulled in from a
database using a Query it's wrong.

"Dave F" wrote:

How is the cell formatted? When I enter 6/24/47, I get June 24, 1947
returned.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Keith" wrote:

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?

change the century
 

Keith

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

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


Gord Dibben MS Excel MVP

On Tue, 3 Apr 2007 07:56:08 -0700, Keith
wrote:

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?