Cell format decimals

[Ramthebuffs]

When you format columns to 2 decimal places, it looks correct, but the cell value is still 2.543678093 for example. I remember there is a way to change this to just 2.54. I just can't remember how to do it. I'm not talking about cell format, there is another way to do this right?

[swatsp0p]

=round(A1,2)

Where A1 holds the decimal value. However, this requires use of another cell to get this result. You can then copy/paste>special>values over the original data and delete the other cell.

Good Luck

[bill k]

for example
=ROUND(B1/C1,2)
2 stands for 2 digits

[Ramthebuffs]

Thanks for the help, for some reason I was thinking there was something in the menus that would do this?

[Ramthebuffs]

I found it Tools>>Options>>Calculation>>Calculation as displayed