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