decimal digits

[jk]

Hi,

I have a survey of statistical data in an Excel-sheet
and I want in the right-most column the proportion of
subtotals in %.
This is all fine but I'm getting 7 trailing digits after the
decimal point and I want to reduce these to e.g. 2.
I know I'd make use of ##.## - but where do I put that
format?
Thanks in advance,
Jan

 

[damorrison]

format,numbers tab,customize, type your format in the box

 

[Nick Hodge]

Or...

Format>Cells...>Numbers Tab>Custom and enter in the box.

However there is seldom any need for custom formats. just select Number,
Percentage, etc and select the number of decimal places in the box

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[jk]

Nick & Damorrison,

In the meantime ...
it's even easier: there's a button in the lower toolbar,
in the same section as the $ sign, saying ",00 -> ,0,
with a tip saying "Decreasing Decimal". Just click, while
focus on the cell ...
Thanks both for your posts anyway.
Jan