View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike
 
Posts: n/a
Default adjusting decimal place in protected worksheet in excel 2007

Hi, i have downloaded a worldcup Team electronic wall chart. I find that when
i enter the results into a cell, it puts the numbers in as eg. ".01" The
cells are not big enough to show all this data so it shows as 0, no matter
what score is entered. It is a protected worksheet, so i dont have any way of
formatting the rows. How can i change excel not to show a decimal point?
Thanks