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?