Thread: Excel is changing date format incorrectly
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Khuli[_3_] Khuli[_3_] is offline
external usenet poster
  
Posts: 2
Default Excel is changing date format incorrectly
On Thursday, 27 November 2014 13:19:24 UTC, Claus Busch wrote:
Range("A1") = DateSerial(2014, 9, 1)


Regards
Claus B.

Unfortunately my data originates from SQL and is being returned as a text string, so DateSerial is not an option.
It seems bizarre (to me) that Excel does not use my regional settings as a default format for dates.
Reply With QuoteReply With Quote