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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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
131
Marvo
M
L
  • Solved
Linking Data on Different Tab and Showing Blank Values Instead of Zeroes
Replies
3
Views
82
Fluff
Fluff
H
  • Question
Find zero in double number cell
Replies
9
Views
144
Scott Huish
Scott Huish
D
  • Solved
Converting numbers adding leading zero's.
Replies
2
Views
131
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
128
kj9
K

Forum statistics

Threads
1,215,483
Messages
6,125,064
Members
449,206
Latest member
Healthydogs

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