You can't, unless you want to actually change the value in the cell by the
amount exceeding the second decimal place. If so, this can be done using the
=TEXT() formula and Copy PasteSpecial Values..........

hth
Vaya con Dios,
Chuck, CABGx3



"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