how do i remove the 0 in the cells

E

excelquester

here is the problem, using vlookup ,,, the information is being
transported from pages as requested by formulas,, however if the cells are
empty there appears a ( 0 ) in cells ,, how do i get rid of the
zeros so the cell will be blank so i can print with blank spaces,,, i checked
both pages to insure both are in text form.
EXample:
A1011 A1012
name 0
diet 0
 
E

excelquester

where do i put that formula,, i have a 5 page ,, work book



Master sheet,,,, sheet 1 ,,, sheet 2 ,,, etc
 
D

David Biddulph

You put that formula in the cell(s) where you have a VLOOKUP returning a
zero and you want an empty string.
 
P

Peo Sjoblom

Where the vlookup formulas that return the zeros are, it's a replacement for
your formula wrapped in an IF function to change the zeros to blanks

--


Regards,


Peo Sjoblom
 
J

JWD

Go to tools, options, click on view tab, under window options uncheck "zero
values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top