View Single Post
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

Tools - Options - Calculation

Precision as displayed.

"Wendy - Payroll" wrote in message
...
I am creating a form for employees to fill in. One of the automated
calculations will be a percent that I will either round or truncate to 1
decimal (ex: 15.1%). How do I then use the exact number visible to have
the
form do another automatic calculation in another cell? In other words, I
want the 15.1% to be used instead of a number like 15.094321.