How can I change the caller cell's format into "mm/dd/yyyy"?

  • Thread starter Thread starter yajiv.vijay
  • Start date Start date
Y

yajiv.vijay

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?
 
A UDF cannot change a cell's format. Just set the format in the worksheet in
the usual way.
 
Back
Top