I have a question.

Where have you set the number format to 2 decimal places?

Should be in FormatCellsNumberNumber and set for 2 DP.

Maybe you are set for 0 DP

Did you perhaps go into ToolsOptionsEdit and set "Fixed Decimal Places" to 2?

Normally that would give you 12.34 when you entered 1234 but in a formula the FD
places does not kick in.


Gord Dibben MS Excel MVP

On Sat, 16 Dec 2006 11:08:37 -0600, Dave Peterson
wrote:

I've never seen a bug like this in excel.

If you select the cell
then hit F2 (to edit that cell)
followed by F9 (to convert it to a value)
What do you see in the formulabar?

And hit escape to discard those chanes (or edit|Undo if you hit enter).

I'd double check the numberformat and the columnwidth once more.

wrote:

Thanks for the response Dave.

Sorry for the confusion, I meant to put 6.33% * 2937 NOT 2097. Arg!

My columns are wide enough to display the two decimal places, and I'm
currently in General. I'm really starting to think its just a bug in
excel, which is driving me nuts.

Please, if anyone has any other suggestions, let me know. Once I
acutally figure this out, this sheet is going to save me a lot of time.
Let me know if you need any other info.

Dave Peterson wrote:
First, when I multiply 6.33% * 2097, I get 132.7401.

Are you sure you're looking at the correct formula?

==
And some other comments.

If you format the cell as general and make the column wide enough, then you
should see all the decimals. If the column is too narrow to show all the
decimal places, excel will round the display (not the actual value, though).

If you format the cell as number with 2 decimal places and shrink the column to
only show only the whole part of the answer, you should see ######'s. If you
widen the column, you'll see everything.

wrote:

My wife and I are decent on excel but couldn't figure this one out...

Here is an example of one of my rows:

I'm trying to calculate from within a cell a percentage (6.33%) times
an integer (2,097). What Excel is returning is 186, when it should be
returning 185.91. Also 98.11 rounds down to 98. Any ideas to get Excel
to stop rounding my numbers?

I have the cell set to two decimal places, I've tried many formats
general, number accounting and they all do the same thing.

Thanks in adavance!

--

Dave Peterson