how do i remove the 0 in the cells
 

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
--
ty Bob

how do i remove the 0 in the cells
 

Something like:

=IF(VLOOKUP()=0,"",VLOOKUP())
--
Gary''s Student - gsnu200908


"excelquester" wrote:

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
--
ty Bob

how do i remove the 0 in the cells
 

=IF(vlookup_formula=0,"",vlookup_formula)

--


Regards,


Peo Sjoblom


"excelquester" wrote in message
...
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
--
ty Bob

how do i remove the 0 in the cells
 

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



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



--
ty Bob


"Gary''s Student" wrote:

Something like:

=IF(VLOOKUP()=0,"",VLOOKUP())
--
Gary''s Student - gsnu200908


"excelquester" wrote:

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
--
ty Bob

how do i remove the 0 in the cells
 

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

"excelquester" wrote in message
...
where do i put that formula,, i have a 5 page ,, work book



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



--
ty Bob


"Gary''s Student" wrote:

Something like:

=IF(VLOOKUP()=0,"",VLOOKUP())
--
Gary''s Student - gsnu200908


"excelquester" wrote:

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
--
ty Bob

how do i remove the 0 in the cells
 

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


"excelquester" wrote in message
...
where do i put that formula,, i have a 5 page ,, work book



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



--
ty Bob


"Gary''s Student" wrote:

Something like:

=IF(VLOOKUP()=0,"",VLOOKUP())
--
Gary''s Student - gsnu200908


"excelquester" wrote:

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
--
ty Bob

how do i remove the 0 in the cells
 

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

how do i remove the 0 in the cells
 

ty so much, this did the trick
--
ty Bob


"JWD" wrote:

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