Cannot get cell to display value as date

[nigelandrewfoster]

Hiya

Not come across this before. I wrote a line of code to copy a range in one workbook to a range in another, but the dates in the date column were replaced by their serial numbers.

As you can see, I didn't use PasteSpecial Paste:=xlvalues.

Now when I select one of these serial numbers it displays AS A DATE in the formula bar, but not on the sheet. Formatting the cell with a date format does not work.

Any ideas??

With ThisWorkbook.Worksheets("Incoming Orders")[B] 
        rngOrders.Resize(, 20).Copy .[a2][/B]
        rngOrders.Offset(, 23).Resize(, 8).Copy .[x2]
        rngOrders.Offset(, 33).Resize(, 4).Copy .[ah2]
    End With

 

[RoryA]

Sounds like that sheet is set to display formulas, not their results. Try pressing Ctrl+` to switch it back.

 

[nigelandrewfoster]

Sounds like that sheet is set to display formulas, not their results. Try pressing Ctrl+` to switch it back.

Never thought of that. In fact, never noticed that before! Thanks so much. Your help is always very much appreciated.

 

[RoryA]

Glad to help.