LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Merge data from xcel to word

You may want to try something like this:
http://www.gmayor.com/formatting_word_fields.htm

Regards,
Ryan---

--
RyGuy


"David Biddulph" wrote:

You could use a helper cell with a formula like =TEXT(A2,"$0.00")
or otherwise there are field formatting facilities in Word, for which
hopefully the Word experts can give advice.
--
David Biddulph

"jpcontrol" wrote in message
...
I am having a problem with dollar amounts showing to many decimal places
after the . sign. I have tried to format the cell to only show 2 places,
but
in the word document is shows 6 places after the decimal.




 
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
kindly help me w/mail merge in xcel;40recipients1 text Taha Excel Discussion (Misc queries) 3 October 25th 07 11:38 PM
cannot get certain files and folders to open in xcel and word vikes fan Excel Discussion (Misc queries) 2 February 22nd 07 05:25 PM
xcel/Word 2007-mailmerge problem. Bob Tourkow Excel Discussion (Misc queries) 1 July 25th 06 09:32 AM
mail merge excludes my headers and critical data in Word merge Nix Excel Discussion (Misc queries) 0 April 21st 06 08:35 PM
How to paste Xcel tables legibly into Word . Help!! Nimo Excel Discussion (Misc queries) 1 December 14th 04 09:53 PM


All times are GMT +1. The time now is 11:29 PM.

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"