Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adjusting decimal place in protected worksheet in excel 2007
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adjusting decimal place in protected worksheet in excel 2007
Hi Bob, thanks for that but I am using 2007beta, I could not find "Tools
Options" button. I have since found it in the file menu, in the bottom bar! "Bob Phillips" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a protected worksheet in Excel 3003 | Excel Discussion (Misc queries) | |||
How to Copy a Password Protected Excel Worksheet | Excel Worksheet Functions | |||
Enter comments in a protected Excel worksheet | Excel Worksheet Functions | |||
Merging data from an excel worksheet into an excel template | Excel Worksheet Functions |