accounting issues in excel

[Tyler]

I have prices listed in my exacel data sheet as follows: 1.20, 1.14, 1.30,
1.10, ect.
all of the numbers that end in a zero (1.20, 1.30, 1.10) only display a
value of 1.1 or 1.2 oe 1.3. The data shows up in excel as 1.10 and 1.20, but
the actual value is not that. I have tried to change the formatting but
nothing works. I am mail merging this excel data into word and my prices on
my mail merge are missing the end zero and we can't have that.
Any suggestions?

 

[Dave Peterson]

You can use a custom format so that you can see two decimal places:
format|cells|number tab|custom category: #,##0.00

But that won't help with your mail merge into MSWord.

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/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"#,##0.00")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

 

[Tyler]

thanks
that works wonderful!
tyler

You can use a custom format so that you can see two decimal places:
format|cells|number tab|custom category: #,##0.00

But that won't help with your mail merge into MSWord.

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/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"#,##0.00")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

 

[BoniM]

When you merge into Word, the value but not the formatting is displayed. You
can change the format in Word, tho.
In the Word document, hold down the Alt key and hit F9. This will display
all of the field codes. Add the following switch to your price field:
\# #.00
The entire field code would look something like this:
{ MERGEFIELD "Price" \# #.00 }
Hold down Alt and hit F9 again to turn off the field codes.
If you don't see the change right away, toggle the View merged data button.
If you have values in the thousands, change the format code to #,###.00 to
display commas if necessary.
Good luck!