DDE Request from Excel a value, not what is dispalyed

Hi,



I am trying to import data from an excel spreadsheet.



Works fine mostly but I have a date that is formatted in excel "5-Feb" i.e no year, I like it this way.



The underlying value does include the year, i.e 05-2-2015



When I use DDE Request as below it imports exactly as formatted so no year.



Don't want to change the spreadsheet in any way.



Is there a way to import the value. Don't want a big programming change as only a small issue occassionally effecting me but just enough to annoy me.



Chan = DDEInitiate("Excel", ExcelWkend & ".xls") ' Establish link with new



XName = DDERequest(Chan, "R" & I & "C3")

XDate = DDERequest(Chan, "R" & I & "C4")

XCost = DDERequest(Chan, "R" & I & "C5")



Thanks I/A

DDE Request from Excel a value, not what is dispalyed