On Sat, 10 May 2008 01:33:01 -0700, mehvish91
wrote:

i would like to know if the following 2 procedures are possible and, if
possible, how to carry them out-
1) for example, if i type the name of a month, say may, and in the next cell
i type a no., say 5, it should automatically fill out like this-'05-05-2008'

C1: =--(A1&B1) and custom Format as mm/dd/yyyy (or dd/mm/yyyy, depending
on what you want).
--ron