View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default 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.