View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jay1004x jay1004x is offline
external usenet poster
 
Posts: 1
Default DISPLAYING RESULTS OF A FORMULA

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?