View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] yajiv.vijay@gmail.com is offline
external usenet poster
 
Posts: 10
Default How can I change the caller cell's format into "mm/dd/yyyy"?

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?