Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
To use Excel table as a source for MS Word Mail Merge, better create a special table for it, where all numeric and date values are replaces with strings. I.e. when in your original table the date was p.e. in cell B5 on sheet Data, then in new table in cell B5 you have the formula =TEXT(Data!B5,"dd/mm/yyyy") -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Patsy Rogge" wrote in message ... Hi We are trying to do a merge from Excel to Word in Office 2003. The date format we need is DD/MM/YYYY. In Excel it displays correctly, but as soon as you merge to word, it swops the format around to MM/DD/YYYY. It also swops the format around in the Excel file at that point. We have checked the regional settings and everything is correct. Has anyone got any ideas??? Thanks -- Patsy Rogge -- Patsy Rogge 012-420 7240 012-420 7230 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
We are trying to do a merge from Excel to Word in Office 2003. The date format we need is DD/MM/YYYY. In Excel it displays correctly, but as soon as you merge to word, it swops the format around to MM/DD/YYYY. It also swops the format around in the Excel file at that point. We have checked the regional settings and everything is correct. Has anyone got any ideas??? Thanks -- Patsy Rogge -- Patsy Rogge 012-420 7240 012-420 7230 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In article , "Arvi Laanemets" wrote:
Hi To use Excel table as a source for MS Word Mail Merge, better create a special table for it, where all numeric and date values are replaces with strings. I.e. when in your original table the date was p.e. in cell B5 on sheet Data, then in new table in cell B5 you have the formula =TEXT(Data!B5,"dd/mm/yyyy") Other possibility is to make sure you get the data via DDE. The other options certainly give other formating problems. Bruce ---------------------------------------- I believe you find life such a problem because you think there are the good people and the bad people. You're wrong, of course. There are, always and only, the bad people, but some of them are on opposite sides. Lord Vetinari in Guards ! Guards ! - Terry Pratchett Caution ===== followups may have been changed to relevant groups (if there were any) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to merge excel and word documents | Excel Discussion (Misc queries) | |||
Field missing on completed mail merge Excel - Word once merged | Excel Discussion (Misc queries) | |||
How do I merge from Excel into Word doc and retain formatting? | Excel Discussion (Misc queries) | |||
Excel cell filler for word merge document | Excel Discussion (Misc queries) | |||
EXCEL Decimal changes during WORD Merge | Excel Discussion (Misc queries) |