An intersting problem!

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Hi everybody,
I have an intesting formatting problem . In one of the cells I forammted the
cell with custom 0.0%;(0.0%) now when the number is less than 10,000% it
doesn't show (cell is blank). Any thoughts?
 
Edward,

You might have conditional formatting that hides the value for that range: try Format / Conditional
Formatting... Delete all conditions.

HTH,
Bernie
MS Excel MVP
 
thanks Bernie, you were right on the money !
--
Best regards,
Edward


Bernie Deitrick said:
Edward,

You might have conditional formatting that hides the value for that range: try Format / Conditional
Formatting... Delete all conditions.

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Back
Top