Excel 97 1

[Skyshadow5]

A colleague used to be able to input a date (UK format) using the numeric keypad i.e. 1.9.3 and the cell would display 01-Sep-2003 however, since some problems occured and IT did whatever it was they do, she can no longer enter a date this way. I've tried various formats both date and custome but cannot get excel to recognise 1.9.3 as a date input. Can anyone tell me how to achieve this please?
Clive - UK

 

[Adnane]

you put 1.9.3 for the year 2003. what about for example 1999. do you put .99 or .9?


Adnane

http://www.microsoft.com/northafrica

 

[Skyshadow5]

Never had to try as this way of entering the date has only been done for the last couple of years, sorry.

 

[combo]

Check date separator and short/long date formats in control panel>regional settings>date tab. A universal date separator is "/".

combo

 

[Skyshadow5]

Thanks combo, that's done the trick.