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

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
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
89
Marvo
M
L
  • Solved
Linking Data on Different Tab and Showing Blank Values Instead of Zeroes
Replies
3
Views
61
Fluff
Fluff
H
  • Question
Find zero in double number cell
Replies
9
Views
98
Scott Huish
Scott Huish
D
  • Solved
Converting numbers adding leading zero's.
Replies
2
Views
103
Davebro
D
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
103
kj9
K

Forum statistics

Threads
1,215,048
Messages
6,122,862
Members
449,097
Latest member
dbomb1414

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