Hello.

I have a cell, A1 say, with value 0.1245433212 that I have rounded using the toolbar so that the cell now shows 0.12.

In another cell I want to pass the rounded value of A1 by refering to its cell address, i.e. the number 0.12. However if I refer to the cell by for instance letting the formula for A2 be "My A1 value = "&A1 it will pop out "My A1 value = 0.1245433212" in cell A2.

Is there a Excel function that can help me to pop out the rounded animal?

I would like to control the rounding by rounding the original value in A1 and not use the ROUND()-function on A2. Of course, if there is a function to return how much my value in A1 is rounded that is just great.

Best regards.