Forum Discussion
jpinto521
Apr 03, 2023Copper Contributor
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 ...
jpinto521
Apr 04, 2023Copper Contributor
Thank you for your input as well.
Already solve my problem by using this format _($* #,##0_);[Red]_($* (#,##0);"".
Best Regards,
SergeiBaklan
Apr 04, 2023Diamond Contributor
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.