Hi hope this is the correct forum. I have a simple formula that returns a value, sometimes 0. What is the setting / formula to use if i want the 0 value to show blank cell?
Thanks!
Hi hope this is the correct forum. I have a simple formula that returns a value, sometimes 0. What is the setting / formula to use if i want the 0 value to show blank cell?
Thanks!
Last edited by Schalk; 03-16-2022 at 09:37 AM.
Apply a Custom Format to the cell with the formula:
General;-General;;
The two semicolons at the end will make zero values display as blanks.
Hope this helps.
Pete
That works thanks, but what if when the value is not 0 and I want to to show a currency like $23.00. Can this be done?
Alternatively, with a formula:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
In File...Options...Advanced you have the ability to untick the 'Display Options for this worksheet...Show a zero in cells that have zero value'
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
another approach is to use Conditional Formatting
- highlight the cells you want this to apply to
- go to Conditional Formatting > New Rule
- format only cells that contain > cell value equal to zero
- format > number > custom > use the format from Pete_UK's post
A slightly longer way to set it up, but it means you can change the formatting of non-zero data more easily
<<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks