P Peter Mar 31, 2004 #1 Anyone know how to make excel recognise info as a date when it is entered as 31.3.04 as opposed to 31/3/04 or 31-3-04?
Anyone know how to make excel recognise info as a date when it is entered as 31.3.04 as opposed to 31/3/04 or 31-3-04?
F Frank Kabel Mar 31, 2004 #2 Hi Peter try formating the cells prior to entering values with the format DD.MM.YY
J Jason Morin Mar 31, 2004 #3 You could convert it with a formula: =SUBSTITUTE(A3,".","-")*1 Format as date. HTH Jason Atlanta, GA
