A UDF cannot change a cell's format. Just set the format in the worksheet in
the usual way.
--
Gary''s Student - gsnu2007d


" wrote:

I have a user defined function which returns a date. I want to set the
caller cell's format to "Date" before placing my result. How can i do
that?
I tried with this code but i am getting a number...If i change the
cell format into date manully, it works fine.

Function ReturnDate() as date
ReturnDate="2/11/2008"
range(application.caller.address).numberformat="mm/dd/yyyy"
End Function

Inside sheet...
=ReturnDate()

where did i go wrong?