Data is very often displayed differently than it is stored... formatting can only change the appearance of data; formatting is not capable of changing values.



To see the true contents of a cell, select the cell and look at the Formula bar (wide white thing above the column letters). I suspect cell A2 is lying to you.

It appears you have the cell number format limited to two decimal places.

The actual cell values ofr your calculations is

C2: 0.0925798192771084
D2: 59.2510843373494

Just change your cell formats to see the rest of the numbers.

Cheers,

P.S. - I think Kimberly meant C2 vice A2.

I had earlier pasted a section of the Excel sheet into an Open Office spreadsheet to confirm the problem. When confirmed, I posted my question on their forum in addition, needing a resolution before this Friday.

Remembering my initial post problem was that the spreadsheet value returned from the multiplication was ~1.65 different than that returned by a calculator (59.25 vs. 57.60).

The answer you guys gave does not change that fact--the answer is still 59.25xxxxx. But the answer that the Oo person returned did provide a way to align the calculator vs. spreadsheet as quoted below:

"Use a calculator and multiply .09*640 and you get 57.6. The actual value in the cell is .0926 rounded to four decimals. .0926*640=59.264 according to my calculator not a spreadsheet. A spreadsheet always uses the exact value no matter how you format the cell for display purposes.
Go to Tools-->Options-->Openoffice.org Calc-->Calculate and check the box "Precision as Shown" and you will get the result I show above in your spreadsheet."

Since this spreadsheet will be given to a group of folks who use calculators far more than spreadsheets, the numbers need to match that of a calculator. I do not see an option within Excel that corresponds to the 'Precision as Shown' option of Oo? Is there one or a way of getting a similar result?