Excel Dates

  brambles 21:11 18 Nov 05

Eldest daughter driving me mad.

At business she is working on a database in Excel.

She tries to shorten the DOB entry as for example
23/11/29 for someone born in 1929 but it comes out as 23/11/2029 yet when she enters 23/11/31 it comes out as she wants it as 23/11/1931. Is there something we need to format in Cells/Date?


  v1asco 21:18 18 Nov 05

and have the same problem! Using excell 2000 and my cells are formatted correctly. Very strange, however there are lots of very helpful people on this site and here's hoping.


  VoG II 21:35 18 Nov 05

Format the cells in which dates are added in the form DD/MM/YY as Text.

Then in another column enter the following formula and copy down


(this assumes that the DD/MM/YY is in Column A starting in Row 1).

If you take this approach it is important to always enter the correct number of digits, e.g. 1 June 1949 would be entered as 01/06/49.

Having said all that, this is really only important if calculations are to be done on the dates - if not they could simply be formatted as Date - dd/mm/yy and would display correctly.

  brambles 17:58 19 Nov 05

Thank you bugle + VoG™ I'll pass the information on


This thread is now locked and can not be replied to.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

What’s happening in VR right now: From psychedelic art to combat therapy

Siri not working? Try these troubleshooting fixes