Format date in destination cell

[Guest]

I have a spreadsheet that uses VB programming to transfer data entered on one
spreadsheet to another spreadsheet. To get the data to the 2nd spreadsheet
the cells are set up with General formatting. This doesn't work out with
date formatting. Is there a way I can set up the destination cell to receive
the date in the proper format?

Susan

 

[Fred Smith]

You can easily format the destination cell in VB, either before or after the
copy. You would use a statement like:

Range("A1").NumberFormat = "mm/dd/yyyy"