Dim dt as Date
dt = Cdate("22/09/2008")
ActiveCell.Value = dt
ActiveCell.Numberformat = "dd/mm/yyyy"

--
Regards,
Tom Ogilvy

"rebel1970 " wrote in message
...
Hi there,

Can anyone help me.... I have a macro which copies a variable to a
cell.

The variable format will always be dd/mm/yyyy

However, this information makes its way to the cell but it doesnt seem
to be the value of the cell.... its almost as if it is text sitting on
the cell and not a value. Like for example ="22/09/2008"

Any help much appreciated

R


---
Message posted from http://www.ExcelForum.com/