Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.formatting.longdocs
 
Posts: n/a
Default Word XP decreasing decmials in calc

Not sure if this is the right group.

In Word XP (SP3 - latest securty, W-XP SP2, 1.4GHz, Latitude D600),
I've mailmerged somce values from Access XP. The merge numbers are ok
(formatted Single with 10 decimal places in Access).

When performing a simple calc (division), Word is displaying the right
number of decimal places. The equation looks like:
=1.02154*.45 + 1.104*.2 + 1.01613*.1 + 1.04167*.25
The 5 decimal place numbers are all calculated (from mailmerge values)
and formated as:
{bookmark \# "#,###.#####"}
When performing the next calculation, Word seem to be losing one
decimal place for each new figure in the equation.
Should be:
=.45965 + .2208 + .10161 + .26042 (.2208 is only 4 places anyhow)
Word is returning (this is with formatting as {bookmark \#
"#,###.#####"}):
=.45965 + .2208 + .101 + .26
If I changed the format (for the last component) to {bookmark \#
"#,##0.00000"}, Word returns:
=.45965 + .2208 + .101 + .26000

Any ideas?

TIA

 
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
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM
How can Word display full path of a file in the title bar? SAsif Microsoft Word Help 1 January 26th 06 04:32 PM
Does Word have a QuickCorrect/Quick Word option like WordPerfect? CW New Users 2 December 20th 05 05:54 PM
In Word, how do I surpress headers and footers on page 2 Bill Microsoft Word Help 1 December 15th 05 06:13 PM
In Word, how can I see all files (*.*) in "save as"? citizen53 New Users 8 April 4th 05 04:56 PM


All times are GMT +1. The time now is 01:49 PM.

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

About Us

"It's about Microsoft Word"