Thread: [Solved] Mail merge date format
View Single Post
 
Old 07-28-2016, 05:05 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,383
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The problem is most likely due to having two different date formats in use in your data source (d/m/yyyy and m/d/yyyy - or a variation on those). US systems usually default to something based on m/d/yyyy but other regions typically use something based on d/m/yyyy. If you're using a UK system, for example, but are trying to input dates with a m/d/yyyy format, Excel won't know that a date input as 10/04/2012 is 4 October 2012 and not 10 April 2012 unless the cell is pre-formatted for d/m/yyyy dates. The converse also applies.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote