cell rounding of value automatically
Hello
i am working on this worksheet, and it is rounding off the value in certain cells automatically.
e.g. if i have a value 2.98 in cell c3 and i make the value of the cell in question say c56 =c3
it gives a value of 3
actually i discovered that the cell does not like any fractional number, if i directly try to input 3.1 it rounds it of to 3
Re: cell rounding of value automatically
Did you format the column as numeric and designate the precision?
Re: cell rounding of value automatically
actually it was a legacy sheet and some one had reduced the precison to zero decimal points :)