| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how to get excel formatted date in word during mail merge
When I tried to merge custom formated date (mmmm dd, yyyy) from excel, the
merged document is showing the date as number. How to have the date in the format i required. I am using Office 2003 |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
how to get excel formatted date in word during mail merge
Hi azhagesan,
What sort of number are you getting (eg 38708, 12202005)? Cheers "azhagesan" wrote in message news  When I tried to merge custom formated date (mmmm dd, yyyy) from excel, the merged document is showing the date as number. How to have the date in the format i required. I am using Office 2003 |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
how to get excel formatted date in word during mail merge
You need to re-format the date in Word - something like DATE \@ "dd/MM/yyyy"
where DATE is your field name. If you hit Alt/F9 you will see the field format rather than the result. Then Alt/F( to switch back again Sheila "azhagesan" wrote: When I tried to merge custom formated date (mmmm dd, yyyy) from excel, the merged document is showing the date as number. How to have the date in the format i required. I am using Office 2003 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
| Mail Merge Word 2003 Issue | Mailmerge | |||
| cannot mail merge from excel to word | Mailmerge | |||
| Mail Merge does not accept formatted cell of Excel | Mailmerge | |||
| Mail Merge date format problem with Word 2003 | New Users | |||
Linear Mode
