View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mattlynn via OfficeKB.com Mattlynn via OfficeKB.com is offline
external usenet poster
 
Posts: 140
Default The formula result is 76% but the cell shows 0%. Why?

if you wish, you can email me the speadsheet to look at.


SteveB wrote:
yes

Are the cells formatted to %, to 2 decimal places??

[quoted text clipped - 3 lines]
cell shows 0% but when I click the fx button it gives the answer as 76%
(which is correct) but it just won't show the result in the cell!


--
Matt Lynn

Message posted via
http://www.officekb.com