There is an option in Excel which you may find useful.

From the Tools menu, choose options. Go to the Calculation tab, check the
checkbox "Precision as displayed".

But use it very carefully.

Regards,
Edwin Tam

http://www.vonixx.com



"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