Decimal place formatting button doesn't work when some cells already have no decimals

[Tripp Knightly]

Say I have 2 cells w/ values:

35 35.87

If I use the formatting bar button to drop the decimal places, nothing
happens, and I get an error tone.

My recollection is usually Excel "does the right thing" and will drop
the decimals on those cells for what it can (and this is what I want
to happen).

So in what arcane place to I configure this to work the way I want it
to?

Thx

 

[Guest]

Dear TrippKnightly

I understand you want to show the cells entered as 35 and
35.87 as 35 and 36 respectively?

To do this, highlight the cells you wish to format with
no decimal points. And go Format/Cells/Number and select
the category : number and choose zero decimal points.

Excel defaults to a General formatting - ie. no number
formatting, until a format is applied as above.

Hope this helps.

Cheers
TrippLightly

 

[Tripp Knightly]

You understand correctly, and thanks yes I know I can use the format
command as you describe.

My particular concern was why / under what circumstances the decimal
formatting button was failing to act as it should. (The button is
faster
than hierarchical menus, anway.)