| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
An intersting problem!
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An intersting problem!
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
An intersting problem!
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Linear Mode
