DISPLAYING RESULTS OF A FORMULA

J

jay1004x

If for example I put a formaul such as =5/3 into a cell, I know I can format
the cell to display just 1.67. But if I copy and paste the value into a cell
that is formatted to display only 2 decimals, the cell will display 1.67, but
the formula bar displays 1.666666666667. Is there a way, to have the formula
bar display only 1.67 also?
 
G

Gary''s Student

Say in A1 we have
=5/3
in B1 enter:
=ROUND(A1,2)
then copy B1 and paste/special/value into C1 to get your desired result.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying formulas-displaying results 1
Decimal points data not displaying as expected 2
Displaying results in formula bar when cell is hidden 1
Formula Bar - display of content 4
How to write a formula for a price that is multiples for one amoun 2
Formula result not displaying correctly 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel Formula Bar Time Display Format 2

Top