Goto ToolsOptions 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)

"Mike" wrote in message
...
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