Say A1 contains 15.6403954300535

In an un-used cell, enter =ROUND(A1,2)
Copy this cell and paste/special as value back into A1
--
Gary's Student


"MAC" wrote:

Hi,

I have currently formatted a column of cells to decimal place of 2,
displaying each cell as eg. 15.64 however within the Formula Bar it
displays as :
15.6403954300535 ?

How can I make it so that the Formula Bar info displays the same as the Cell
block?

Thanks for your help.
Regards