Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting in Mail Merge
I have an Excel spreadsheet, showing dates when a succession of different
stages are reached for each client in my conveyancing job. All dates are in UK format in Excel. However, when I mail merge in Word using this data source, all dates appear in Word as US format, and any empty cells are populated with 12:00AM. Could you please tell me if this is an Excel problem, and what the solution may be. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting in Mail Merge
Debra Dalgleish posted this to a similar question:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. ======= I often cheat and just use another cell: =text(a2,"mm/dd/yyyy") and use this text cell in the mail merge. Lighthouse wrote: I have an Excel spreadsheet, showing dates when a succession of different stages are reached for each client in my conveyancing job. All dates are in UK format in Excel. However, when I mail merge in Word using this data source, all dates appear in Word as US format, and any empty cells are populated with 12:00AM. Could you please tell me if this is an Excel problem, and what the solution may be. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting in Mail Merge
Thanks for that Dave, it's worked a treat - it changes the US dates to UK
format. Thank god for that! Unfortunately, the empty cells that were 12:00AM are now showing today's date. I just want them to be empty. Is there a way of telling it to leave empty cells as empty? Many thanks for your efforts Dave, I'm half-way there at least! "Dave Peterson" wrote: Debra Dalgleish posted this to a similar question: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. ======= I often cheat and just use another cell: =text(a2,"mm/dd/yyyy") and use this text cell in the mail merge. Lighthouse wrote: I have an Excel spreadsheet, showing dates when a succession of different stages are reached for each client in my conveyancing job. All dates are in UK format in Excel. However, when I mail merge in Word using this data source, all dates appear in Word as US format, and any empty cells are populated with 12:00AM. Could you please tell me if this is an Excel problem, and what the solution may be. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting in Mail Merge
I'd still use that extra cell:
=if(a1="","",text(a1,"mm/dd/yyyy") Lighthouse wrote: Thanks for that Dave, it's worked a treat - it changes the US dates to UK format. Thank god for that! Unfortunately, the empty cells that were 12:00AM are now showing today's date. I just want them to be empty. Is there a way of telling it to leave empty cells as empty? Many thanks for your efforts Dave, I'm half-way there at least! "Dave Peterson" wrote: Debra Dalgleish posted this to a similar question: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. ======= I often cheat and just use another cell: =text(a2,"mm/dd/yyyy") and use this text cell in the mail merge. Lighthouse wrote: I have an Excel spreadsheet, showing dates when a succession of different stages are reached for each client in my conveyancing job. All dates are in UK format in Excel. However, when I mail merge in Word using this data source, all dates appear in Word as US format, and any empty cells are populated with 12:00AM. Could you please tell me if this is an Excel problem, and what the solution may be. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
retrieve cell formatting with IF(HLOOKUP) formula | Excel Worksheet Functions | |||
cell formatting problems | New Users to Excel | |||
Trying to add conditional formatting to every other cell...GOING . | Excel Worksheet Functions | |||
Cell formatting behaviour question | Excel Discussion (Misc queries) |