Convert Zeros to Blanks

J

jeff007

New Member
Joined
Jul 7, 2006
Messages
27
Convert Zeros to Blanks--2007 Excel - I have an invoice that has cells that result in 0 , how can I format the page to get rid of the zeros?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
0 can reveal a lot, but you could CF it to a invisible colour
 
Upvote 0
You could do a if statement in those cells . . . . . IF({formula}=0,"",{formula})
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Returning a blank instead of a zero
Replies
2
Views
81
Marvo
M
H
  • Question
Find zero in double number cell
Replies
9
Views
97
Scott Huish
Scott Huish
K
  • Question
Macro to convert multiple CSV's into a single xlsx file with multiple workbooks (each workbook is the name of the csv file)
Replies
0
Views
99
kj9
K
S
  • Solved
Detect if a value goes down in a row of numbers, but not if there is a zero
Replies
8
Views
133
Peter_SSs
Peter_SSs
SaraWitch
  • Solved
Show blank if no value in previous cells and show an accounting zero if zero entered in previous cells
Replies
5
Views
226
felixstraube
F

Forum statistics

Threads
1,214,834
Messages
6,121,873
Members
449,056
Latest member
ruhulaminappu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top