View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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?