Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot enter 0% into a cell
Hi all
Somebody has created a workbook and sent it to me for completion. I have to enter a percentage figure into one of the columns, however, if I enter 0%, it disappears and doesn't display anything - I can still see it in the formula bar but it doesn't show? I can enter any other percentage or text and it appears fine. I have checked for any conditional formatting and data validation and cannot find anything. There are also no formulas in these cells either. Does anybody have any idea what else could have been done to this worksheet so it doesn't show 0% but shows everything else? Any help would be appreciated. Thank you. Louise |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot enter 0% into a cell
Tools Options View and check the Zero values box near the bottom.
-- Gary's Student "Louise" wrote: Hi all Somebody has created a workbook and sent it to me for completion. I have to enter a percentage figure into one of the columns, however, if I enter 0%, it disappears and doesn't display anything - I can still see it in the formula bar but it doesn't show? I can enter any other percentage or text and it appears fine. I have checked for any conditional formatting and data validation and cannot find anything. There are also no formulas in these cells either. Does anybody have any idea what else could have been done to this worksheet so it doesn't show 0% but shows everything else? Any help would be appreciated. Thank you. Louise |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot enter 0% into a cell
They have disabled the display of zero values.
Go to Tools OptionsView tab and check the Zero values checkbox. Note: This will show zero values throughout the sheet (ie anywhere that a formula results in zero, or zero has been manually entered) -- Ian -- "Louise" wrote in message ... Hi all Somebody has created a workbook and sent it to me for completion. I have to enter a percentage figure into one of the columns, however, if I enter 0%, it disappears and doesn't display anything - I can still see it in the formula bar but it doesn't show? I can enter any other percentage or text and it appears fine. I have checked for any conditional formatting and data validation and cannot find anything. There are also no formulas in these cells either. Does anybody have any idea what else could have been done to this worksheet so it doesn't show 0% but shows everything else? Any help would be appreciated. Thank you. Louise |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot enter 0% into a cell
Well, all the years I've been using Excel, I never knew that was there!
Thanks very much. Louise "Gary''s Student" wrote: Tools Options View and check the Zero values box near the bottom. -- Gary's Student "Louise" wrote: Hi all Somebody has created a workbook and sent it to me for completion. I have to enter a percentage figure into one of the columns, however, if I enter 0%, it disappears and doesn't display anything - I can still see it in the formula bar but it doesn't show? I can enter any other percentage or text and it appears fine. I have checked for any conditional formatting and data validation and cannot find anything. There are also no formulas in these cells either. Does anybody have any idea what else could have been done to this worksheet so it doesn't show 0% but shows everything else? Any help would be appreciated. Thank you. Louise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
Lock the cell once enter the data | Excel Worksheet Functions | |||
Stop next cell being selected on Enter | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |