View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelquester excelquester is offline
external usenet poster
 
Posts: 7
Default 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