Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"Bob Phillips" wrote in message
... Round it to 0 decimal places. -- HTH RP (remove nothere from the email address if mailing direct) Well Bob, I retract what I said earlier. Even though I was correct in my response about rounding, your suggestion worked on that one column of the spreadsheet where I was having this (0)'s showing. Even though the entire spreadsheet is rounded to 2 decimal places, with 0 decimal on formatting, that last column shows properly if I round it to 0 decimal places ... And that should be fine, because all the numbers making up that total column have been rounded to 2 decimal places. Thanks for your help and everyone else who have come to the rescue. Much appreciated. Regards, Uncle Ben |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Displaying null values in charts | Charts and Charting in Excel | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Displaying values from zero on graph | Excel Discussion (Misc queries) |