removing zero values

canablitz

New Member
Joined
Mar 17, 2002
Messages
19
hi, i have a shopping basket on my project and when people add purchases to the basket, it adds all of the purchases on the page, even if the quantity is zero, is there any way to remove all the items with zero on them before the contents of the basket is added to the invoice?

BoB

p.s the zero values have 2 other cells related to them and these are located to the immediate left of the cells with the zero values in them, and i need these to be removed aswell
This message was edited by canablitz on 2002-04-10 01:12
This message was edited by canablitz on 2002-04-10 01:22
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Hi Bob

Not sure if you want them removed or just hidden, but to remove try, Edit>Replace then type a "0" in the "Find What:" box, leave the "Replace With:" box empty.

*VERY IMPORTANT: Make sure you check the "Match Case" AND the "Find entire Cells Only" Options.



_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training
OzGrid.BusApp.170x45.gif

This message was edited by Dave Hawley on 2002-04-09 07:23
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

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