| | |
| |||||||
| Forums | Register | Groups | Awards | Arcade | Pets | T-Bucks / T-Store | Invite Your Friends | All Albums | Projects | Blogs | Mark Forums Read |
| Microsoft Applications Discussions about Windows and other MS Products such as Office |
 |
| | LinkBack | Thread Tools |
10-23-2005, 18:02
| #1 (permalink) |
| Civilians |  decimal digits 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 |
     |
| Trackpads Information |
| |
|
10-23-2005, 18:02
| #3 (permalink) |
| Civilians | Re: decimal digits 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 nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "damorrison" <davemcochrane@yahoo.com> wrote in message news:1130073819.813936.124360@o13g2000cwo.googlegr oups.com... > format,numbers tab,customize, type your format in the box > |
| |
|
10-23-2005, 18:02
| #4 (permalink) |
| Civilians | Re: decimal digits 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 "Nick Hodge" <nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS> wrote in message news:u5sQoY91FHA.2064@TK2MSFTNGP09.phx.gbl... > 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 > nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > > > "damorrison" <davemcochrane@yahoo.com> wrote in message > news:1130073819.813936.124360@o13g2000cwo.googlegr oups.com... >> format,numbers tab,customize, type your format in the box >> > > |
| |
|
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Check Digit calculation (IBAN) - Discrepancies when using numbers with 18 digits or MOD-function | Ritesh Sara | Microsoft Applications | 6 | 06-04-2005 16:00 |
| Digits in text cannot format as Numbers ? | st24961 | Microsoft Applications | 3 | 05-31-2005 04:00 |
| Removing Excess Digits From Cells | Raquel666 | Microsoft Applications | 3 | 02-17-2005 08:00 |
| Column labels show digits instead of letter | Jenni | Microsoft Applications | 1 | 07-16-2004 08:56 |
| convert hh:mm:ss to decimal | Mark Cain | Microsoft Applications | 1 | 06-26-2004 07:38 |
 |  |  |
