Variable Not in the cell

[rebel1970]

Hi there,

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

The variable format will always be dd/mm/yyyy

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

Any help much appreciated

 

[Tom Ogilvy]

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

 

[rebel1970]

Thanks To