adjusting decimal place in protected worksheet in excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Goto Tools>Options and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Hi Bob, thanks for that but I am using 2007beta, I could not find "Tools
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top