SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 378
- Office Version
- 365
- Platform
- Windows
Hi peeps,
To hide zeros, I normally put ;; at the end in the Format Cells Custom section. However, this doesn't seem to work for the Accounting choice (have to use Currency) and was just wondering if anyone knew a workaround? I also thought about conditionally formatting the relevant column, but it's in a table with different coloured rows...
Ta muchly!
To hide zeros, I normally put ;; at the end in the Format Cells Custom section. However, this doesn't seem to work for the Accounting choice (have to use Currency) and was just wondering if anyone knew a workaround? I also thought about conditionally formatting the relevant column, but it's in a table with different coloured rows...
Ta muchly!
