| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get numbers to foot across rows and colums?
How do I get numbers to foot across rows and colums? The numbers foot
correctly in the spreadsheet, but do not when added manually on a report. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get numbers to foot across rows and colums?
Two choices:
1) add a footnote that numbers may not foot due to rounding 2) round the individual numbers to the precision displayed. If you choose #2 and you're displaying 1 decimal place, use =ROUND(cell reference/formula/value goes here,1) for each entry in your column/row "k" wrote: How do I get numbers to foot across rows and colums? The numbers foot correctly in the spreadsheet, but do not when added manually on a report. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I label the colums as numbers and the rows as letters? | Excel Discussion (Misc queries) | |||
| how do I repeat rows at foot of worksheet? | Excel Discussion (Misc queries) | |||
| How do change rows to colums AND columns to rows | Excel Discussion (Misc queries) | |||
| Print few rows with many colums so that rows wrap on printed pages | Excel Discussion (Misc queries) | |||
| How do I name the colums and rows? | New Users to Excel | |||
Linear Mode
