thanks Bernie, you were right on the money !
--
Best regards,
Edward


"Bernie Deitrick" wrote:

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


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

--
Best regards,
Edward