Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Word 2000 Merge Problems

Status
Not open for further replies.

slink9

Programmer
Dec 11, 2000
19
US
I am merging data into Word2000 from a Foxpro table with one record in it. I have numeric fields that go into a table that has the number formatting of \# ###,###.00. If it merges the number 189.xx or 190.xx it completely screws up the number. The following are the tests and results.
190.10 is converted to $191.00
190.50 is converted to $195.00
189.40 is converted to $193.00
189.10 is converted to $190.00
These are dollar values and I tried 188.95 and that is exactly what I got returned. This has been tried on SR1a and non-SR1a. Any ideas what's going on?
 
It could have something to do with your number formating as shown above:

# ###,###.00 with the .00 being the end result of each number.

I would try to change this format or remove the .00 altogether to see it it works.
 
That was my first thought but it was quickly shot down and was proved not to be the problem as evidenced by the working 188.95.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top