Reply
 
Thread Tools Display Modes
  #1   Report Post  
ap2sweet
 
Posts: n/a
Default mailmerging question

how do i add decimals, i.e. zeros, to numbers i mailmerge in word from excel
spreadsheets.

for example on excel i have the # $700.00
but when i mail merge the data into a word template
i get $700

so i don't get the .00

how do i solve this problem?
  #2   Report Post  
S Stone
 
Posts: n/a
Default

How do you have the excel cell/column formated. I tryed both currency as
well as accounting formats and both carried over.

S. Stone

"ap2sweet" wrote:

how do i add decimals, i.e. zeros, to numbers i mailmerge in word from excel
spreadsheets.

for example on excel i have the # $700.00
but when i mail merge the data into a word template
i get $700

so i don't get the .00

how do i solve this problem?

  #3   Report Post  
Graham Mayor
 
Posts: n/a
Default

Whether or not the formatting will carry will be determined by the Word
version and how it is connnected to the data file. With Word 2002/3, the
default is for Word to provide the formatting.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




S Stone wrote:
How do you have the excel cell/column formated. I tryed both
currency as well as accounting formats and both carried over.

S. Stone

"ap2sweet" wrote:

how do i add decimals, i.e. zeros, to numbers i mailmerge in word
from excel spreadsheets.

for example on excel i have the # $700.00
but when i mail merge the data into a word template
i get $700

so i don't get the .00

how do i solve this problem?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
upside-down question mark? jeninboden Microsoft Word Help 3 November 8th 09 04:51 PM
use a 'question mark cursor' to get help me Microsoft Word Help 1 January 17th 05 12:32 AM
When I type a question in HELP I can't connect to online help wikegolfa Microsoft Word Help 0 January 8th 05 05:37 PM
Font question? SJH Microsoft Word Help 4 January 6th 05 10:54 AM
Yet another DDE question! Sheila D Mailmerge 2 December 22nd 04 11:35 AM


All times are GMT +1. The time now is 07:14 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"