Hi all,

I have written a vba macro that takes dates from two seperate workbooks and pastes them into a new workbook.

the 2 source workbooks both have the date format as dd/mm/yyyy, and the workbook they are being copied into also has that format set for the date cells.

however, when the dates are transferred, they display as mm/dd/yyyy, even though the format of the cell is dd/mm/yyyy.

Any ideas on what I am doing wrong?

Thanks

Patrick



Visit my site: http://www.drybonesuk.com

__________________
Visit my site: http://www.drybonesuk.com

Hi Patrick try the following code,
Sub test()
Dim dteDate As Date
dteDate = Now
Range("A1").Value = Format(dteDate, dd / mm / yyyy)
End Sub
You can play around with the format section to make it appear in pretty much any combination you like

Hope this helps
Regards
Rob

thanks very much, that worked a treat!

Visit my site: http://www.drybonesuk.com