Hi,

I am trying to store a cell's value.

Dim sheet As String
sheet = Cells(4, answer).Value

The value of this cell is a date 6/29/2015 for example.
However, the formatting on this cell reads 6-29-15.

The script is copying the 6/29/15, Is there a way to store the 6-29-15.

Thanks!