how to put slash(/) after a number

[mangesh]

hi
i want that excell automatically put slash(/) if I enter a date

for example :- the date is 03/10/2004
now for entering this date i will just type 03 and excell should pu
slash(/) as soon as i put 03 and then slash(/) after 10.

Is these any solution for the sam

 

[JE McGimpsey]

You can't do that in XL (macros are disabled when in Edit mode), but you
can accomplish something similar. See

http://cpearson.com/excel/DateTimeEntry.htm

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/DateTimeEntry.htm