I think I can help you with #1. First, let me say you gave a terrible
example. There is no way to tell from 05-05-2008 which of the 05 is supposed
to be the day and which is supposed to be the month. I'll assume the first
05 is the month for this response. For future reference, when giving dates,
pick a day number greater than 12 so we can tell by looking which part of
the date is which. Anyway, since you didn't say, I'll assume you are putting
the month name in A1 and the day number in B1. The following formula should
do what you want...

=--(PROPER(A1)&" "&B1&", "&YEAR(NOW()))

and Custom Format the cell using mm-dd-yyyy as the custom pattern (and you
should use dd-mm-yyyy if the first 05 was actually the day).

Rick


"mehvish91" wrote in message
...
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'
2) if i've prepared different sheets regarding different customers but i
would like to type the whole data in 1 sheet the data pertaining to
different
customers should automatically transfer to their respective sheets
waiting for your reply
mehvish