Forum Discussion
Format cells
Hi All, I would like your help on the following. I have an excel workbook with several tab that point between them. One particular is capturing the data from other tab cells and is formatted as ...
@NikolineDE,
Thank you.
It really works on a blank cell but i cannot apply it to a cell with values because it will change the format whenever there is a value on a cell.
Best regards,
jpinto521
Thank you.
It really works on a blank cell but i cannot apply it to a cell with values because it will change the format whenever there is a value on a cell.
Best regards,
jpinto521
Just modify a bit format which NikolinoDE suggested. You have references on other cells and all you numbers have accounting format. Select entire range, Ctrl+1, Number -> Custom. It looks like
Now remove everything between second and third semicolons. The rest of custom format will be like
Apply this format, it hides zeroes in the grid.
Thank you for your input as well.
Already solve my problem by using this format _($* #,##0_);[Red]_($* (#,##0);"".
Best Regards,
Thank you for the update. In general you don't need "" at the end. Actual value will be zero in any case, format only hide it. Both ...;"" and ...; work the same way.