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?
|