LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default dates in excel show up as text numbers in merge with word doc

I have five columns with dates in my spread sheet, all are formatted with the
custom function=mm/dd/yy. ( Have also tried the date function 00/00/00). When
I input the dates to Excel they work fine and look like they should look.
However when I try to mailmerge these dates into a word doc two of the
columns work OK. But the dates in the other three colunms come out as a
number. Example the date 09/14/07 becomes 39339 in the word doc. The date
06/17/07 becomes 39250 etc. I normally have the auto filter turned on and I
have tried with it off. It resides on my "P" personnal drive on my networked
computer. I'm using Excel 2003. Any thoughts????
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to merge in Word from Excel numbers 00001 - 20000. RLopez@DocusourceSA Setting up and Configuration of Excel 1 September 12th 07 06:03 PM
How do I show zeros transfered from excel to mail-merge word? Megan Excel Worksheet Functions 3 August 9th 07 04:18 PM
how do i merge numbers from excel to word without them changing Tazz Excel Discussion (Misc queries) 2 May 16th 06 12:49 PM
Number stored as text: Frustrated with Excel-Word Merge Marushel Excel Discussion (Misc queries) 2 March 11th 06 04:43 AM
Numbers after decimal point excel to word mail merge Andy P Excel Worksheet Functions 1 March 15th 05 11:48 AM


All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"