LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Whole Numbers in Excel with Mail Merge

Debra Dalgleish posted this:

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://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

bronxbabe wrote:

I'm running a mail merge. In excel, my numbers are displaying in the cell as
"2", but in the formula area, it's displayed as 2.15342465753425. I would
like it to merge as the whole number 2. Also, my salaries, in the cell are
displayed as $115,000.00, but above in the formula area, it's displaying as
115000. When the merge is run, I would also like those salary numbers to
generate with the dollar sign and comma separator. How can these two number
issues be corrected, if possible.

Thanks in advance,


--

Dave Peterson
 
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
Mail Merge w/ Shared Workbook in Word and Excel 2003 Jim Jimmerson Excel Discussion (Misc queries) 1 October 25th 06 04:24 PM
Mail Merge a Date from Excel to Word Steve Excel Discussion (Misc queries) 1 October 25th 06 12:15 AM
How do I attach an excel document to a word one for mail merge? Ruth Excel Discussion (Misc queries) 1 January 6th 06 10:29 PM
Using Excel for a Mail Merge Dayna Excel Worksheet Functions 0 January 3rd 06 11:17 PM
There should be a mail merge feature between excel and access. Vira-SJH Excel Discussion (Misc queries) 0 January 3rd 06 06:20 PM


All times are GMT +1. The time now is 10:53 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"