Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some cells that have formulas in them on and
old spreadsheet, and when the value of the formula is zero, the cell is blank. I can't remember how I achieved this as I'm having problems repeating it in my new sheet. Format painting the old to the new won't do it. Formatting cells on the old sheet shows me the "general" number format is used, and the example is blank. On the new one, a value of zero is showing in the example box. I thought text formatting would work, but no. Can you help? Thanx ahead, Greg Carter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
when i megre cells that begin with zeros , I lose the zeros | Excel Discussion (Misc queries) | |||
Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
Charting zeros as non zeros | Charts and Charting in Excel | |||
Unwanted Zeros in Excel Chart Displayed Values | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |