R
Ray
This is a multi step process.
1) Convert your formula to text by searching for the = and
replacing with '=
2) Use the Mid function to eliminate the =
3) Use the Concatenate function to join an =; round(; your
formula from 2 above; and ,2) to complete the rounded
formula. Note the ; is only used to separate the elements
of the Concatenate function.
4) Convert the above from text to a formula by using the
text to columns function.
1) Convert your formula to text by searching for the = and
replacing with '=
2) Use the Mid function to eliminate the =
3) Use the Concatenate function to join an =; round(; your
formula from 2 above; and ,2) to complete the rounded
formula. Note the ; is only used to separate the elements
of the Concatenate function.
4) Convert the above from text to a formula by using the
text to columns function.