R
Ritchie
F3 has a formula (E3 * P3) where P3 is a percentage.
When I look at the F3, I see a number like 1324.234562323
and when I try to balance, there is often a slight
difference.
I know I can set a variable (for F3) as currency and then
display the variable (in F3) and the number (on the
formula bar) shows as 1324.23, which is good because that
is the number needed to balance.
The catch is the percentage is sometimes changed after the
macro has run. However, the formula no longer exists and
F3 remains the same after the percentage is changed.
Is there a way to leave the formula in F3 but display the
number in the formula bar as 2 decimals? Thanks for the
help.
Is there a way that
When I look at the F3, I see a number like 1324.234562323
and when I try to balance, there is often a slight
difference.
I know I can set a variable (for F3) as currency and then
display the variable (in F3) and the number (on the
formula bar) shows as 1324.23, which is good because that
is the number needed to balance.
The catch is the percentage is sometimes changed after the
macro has run. However, the formula no longer exists and
F3 remains the same after the percentage is changed.
Is there a way to leave the formula in F3 but display the
number in the formula bar as 2 decimals? Thanks for the
help.
Is there a way that