cell date value
thanks all
"Jacob Skaria" wrote in message
...
Try
=Format(range("start_Date"),"dd-mm-yyyy")
If this post helps click Yes
---------------
Jacob Skaria
"greg" wrote:
OK,
this must be an easy one.
I have a named cell. Start_date
The cell is formated as date. with a date value 7/1/2010
when trying to get the cell value I do not get the date
range("start_date").Value2
It comes out:
40360
so must be something easy.
anyone have an answer?
thanks
|