What controls default date when entering date fragment?

S

Sharon C

I know there has got to be a simple answer to this, but I
just can't find it...

What controls the date that defaults into a cell when you
type in just a day, e.g. when I type in "23", what
causes "23-Jan-00" to default in?

I want it to default to "23-May-04", but since I got my
new PC, I have to specify both the day and the month to
get the correct date.
 
F

Frank Kabel

Hi
if the cell is formated as date the numeric value 23 is interpreted as
date: 23 - Jan - 1900
No chance without macros for other defaults
 
Top