| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I mail merge excell into word, but date displays numbers instead
Example, instead of displaying 3/20/02 it displays 37335. How can I get word
to format the data from excell as date. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I mail merge excell into word, but date displays numbers instead
In your mail merge document, you likely can tell Word what number format you
want (ie m/dd/yy). You could ask in the Word group about it. The simpler option, to me, is to format the merged data in Excel, using something like: =Text(a1,"m/dd/yy") Regards, Fred. "Chaya" wrote in message ... Example, instead of displaying 3/20/02 it displays 37335. How can I get word to format the data from excell as date. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I mail merge excell into word, but date displays numbers instead
In article , "Fred Smith" wrote:
In your mail merge document, you likely can tell Word what number format you want (ie m/dd/yy). You could ask in the Word group about it. The simpler option, to me, is to format the merged data in Excel, using something like: =Text(a1,"m/dd/yy") Alternatively, try connecting to your excel file using DDE. That fixed a number of formatting problems in the final word doc for me. :) "Chaya" wrote in message ... Example, instead of displaying 3/20/02 it displays 37335. How can I get word to format the data from excell as date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting by date & exported to word for mail merge | Excel Discussion (Misc queries) | |||
| Mail Merge a Date from Excel to Word | Excel Discussion (Misc queries) | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
| Using the mail merge function from excell | Excel Discussion (Misc queries) | |||
Linear Mode
