Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |