Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date format for mailmerge
Hi all,
I don't know if I should be posting this here or in the Word newsgroup, so if I'm in the wrong place please point me in the right direction. I use Office XP. I have an excel document with 350 rows of information. I need to merge this information into word. One of the cells has the date. I have entered the date as "dd/mm/yy" and the cell is formatted to show it as "dd mmm yyyy". When i merge this information into word it appears as "mm/dd/yyyy", whereas I would like it to appear as "dd mmm yyyy" - which is how it is displayed in excel. thanks in advance for any help, Luc |
#2
|
|||
|
|||
I did a search on the MS communities and found a solution to this
problem. In case anyone is interested, the response given previously can be found at this link http://www.gmayor.com/mail_merge_lab...th_word_xp.htm Luc Agostini wrote: Hi all, I don't know if I should be posting this here or in the Word newsgroup, so if I'm in the wrong place please point me in the right direction. I use Office XP. I have an excel document with 350 rows of information. I need to merge this information into word. One of the cells has the date. I have entered the date as "dd/mm/yy" and the cell is formatted to show it as "dd mmm yyyy". When i merge this information into word it appears as "mm/dd/yyyy", whereas I would like it to appear as "dd mmm yyyy" - which is how it is displayed in excel. thanks in advance for any help, Luc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |