if you copy some value from anywhere and copy it as a formulae using = sign;it will show 0 as you drag the cell below to copy the values(formulae)
put $ sign to avoid.