Binary problems

[ZacCerrato]

I understand that Excel uses binary math for most mathematical computations...however, this is creating serious problems for me.

In the spreadsheet I use, I introduce an initial number by referencing from an array of "prices". Once referenced, this number is multiplied by a single digit number (0-9, typically "1"). These values look fine within excel, but when I merge from these fields into a word document I get what is obviously the result of binary computations. E.g. I get "198.13999999999999" for what should be "198.14" or "455.93000000000001" for what should be "455.93".

Does anyone know of a way to keep these from happening when Word pulls numerical information from an Excel cell?

I though about doing a Vlookup and having another cell that pulled in whole number values rather than decimals? Is there another way to automatically round up or down to the hundreth place "0.00"?

Thanks in advance!

 

[anglais428]

=ROUND(your_cell_ref,2)

 

[VoG]

Try rounding the values

=ROUND(your formula,2)

 

[Richard Schollar]

When you do the computations in Excel, just wrap the formula in the ROUND() function to prevent this from happening:

=ROUND(A1*B1,2)

to round to 2 decimal places.

 

[Norie]

You could try formatting the mail merge fields in Word using switches.

 

[ZacCerrato]

thank you guys very much!!!

 

[ZacCerrato]

I'm still having problems. I'm wondering if this is because I have one cell which pulls numerical values using =Vlookup(**,**,**,**) which gets thrown into the equation?

Even the cells for which I entered (e.g.) =ROUND(AL548+AM548, 2), these still pull up in word as the result of binary equations.

How would I use switches?