dani9
01-11-2012, 04:27 AM
HI,
i need help with something... I need to divide all zeros in column with 1000000000, so that i get something like 0,0000001.
Cells(2, m).FormulaR1C1 = "=IF(RC[-28]=0,RC[-28]/1000000,RC[-28])"
this is what i have, but the zeros remain like 0,00, and if i increase the number of decimal places, it is still zero.
Does excel vba automaticall round numbers and how do I avoid that, because i need the 0,0000001 number.
Thanks in advance!
i need help with something... I need to divide all zeros in column with 1000000000, so that i get something like 0,0000001.
Cells(2, m).FormulaR1C1 = "=IF(RC[-28]=0,RC[-28]/1000000,RC[-28])"
this is what i have, but the zeros remain like 0,00, and if i increase the number of decimal places, it is still zero.
Does excel vba automaticall round numbers and how do I avoid that, because i need the 0,0000001 number.
Thanks in advance!