MacResource › My Category › Tips and Deals v
Excel thinks 7 + 7 + 3 = 18...what gives?

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Linear Mode
Excel thinks 7 + 7 + 3 = 18...what gives?
Gareth Offline
Posting Freak
*****
Posts: 7,579
Threads: 123
Joined: May 2025
Reputation: 2
#7
12-05-2009, 06:14 AM
ROUND(number,num_digits) will force a cell to round to a given decimal place and thus have WYSIWYG within individual cell(s). Just replace number with the formula you are calculating and num_digits with the number of decimals you want.

i.e. =ROUND(.1*A1,2)
Find
Reply


Messages In This Thread
Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by Gareth - 12-05-2009, 06:14 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)