Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Mail merge help


  • Please log in to reply
2 replies to this topic

#1 rasik786

rasik786

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:02:34 AM

Posted 05 January 2017 - 01:10 AM

I have a mail merged document which is connected to an Excel sheet. The document has a problem with date, if the date is less than or equal to 12, the document will show it as month (I have made the format to dd mmm yyyy); for e.g, if the date is 9-Nov-16, it will show 11-Sep-16. But if the date is above 12, it will give the correct output. e.g, if date is 22-Nov-16, the out put will be 22-Nov-16. Please let me know the how to solve the issue.



BC AdBot (Login to Remove)

 


#2 MoxieMomma

MoxieMomma

  • Members
  • 471 posts
  • OFFLINE
  •  
  • Local time:04:34 PM

Posted 05 January 2017 - 04:23 AM

Hi:
 
Welcome.
 
It would help to know: what version of Excel, please?
 
Also, I have not tried any of these links, but perhaps they might be able to help:
 
Format a date the way you want - MS Excel
 

Date format problem in Mail Merge

https://www.extendoffice.com/documents/excel/3784-excel-convert-dd-mm-yyyy-to-date-format-dd-mm-yyyy.html
http://stackoverflow.com/questions/37609401/change-date-format-of-cell-in-excel-from-dd-mm-yyyy-to-yyy-mm-dd-excel-version
https://www.extendoffice.com/documents/excel/585-excel-change-american-date-format.html
http://ccm.net/forum/affich-661205-change-date-format-dd-mm-yyyy-to-dd-mm-yyyy

Hope this helps,

MM


Edited by MoxieMomma, 05 January 2017 - 04:25 AM.


#3 rasik786

rasik786
  • Topic Starter

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:02:34 AM

Posted 05 January 2017 - 06:51 AM

Microsoft Office professional plus 2010






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users