HOW DO i DISPLAY 2 DECIMAL PLACES WITHOUT HAVING THE NUMBER ROUND

S

Sharonm

I want to display a number in excel with 2 decimal points but I do not want
it to round the calculation. eg: if my answer is 12.85765 I want to display
only the 12.85 but when I choose 2 decimals it changes the number to 12.86.
Any suggestions?
 
D

Dawn Crosier

In a separate cell you could use the Trunc function:

=TRUNC(A1,2)

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message is posted to a newsgroup. Please post replies and
questions to the newsgroup so that others can learn as well.
 
Top