removing zero values

canablitz · Apr 9th, 2002, 08:11 AM

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 ]

Al Chara · Apr 9th, 2002, 08:14 AM

Tools|Options|View|Uncheck "Zero Values"

Dave Hawley · Apr 9th, 2002, 08:22 AM

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

[ This Message was edited by: Dave Hawley on 2002-04-09 07:23 ]

Apr 9th, 2002, 08:14 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Tools\|Options\|View\|Uncheck "Zero Values" __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 08:11 AM	#1
canablitz New Member Join Date: Mar 2002 Posts: 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 ]

Apr 9th, 2002, 08:22 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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 [ This Message was edited by: Dave Hawley on 2002-04-09 07:23 ]