Hi.
I am trying to contain a number value in excel after changing the value
to text.
First, I calculate a cell, then change that cell from a formula to a
value. Then, I want to change the value to a number with 2 digits
after the decimal. My dilemma occurs when the number value shows as 3
digits after the decimal. When I try to reformat for 2 digits, the
number value is displayed with 3 digits. Does that make sense? Please
help!
Biff - 20 Dec 2005 04:44 GMT
Hi!
>Does that make sense?
To be honest, no!
Why don't you use a Round function in your formula then the number of
decimal places will already be set?
For example:
=ROUND(SUM(A1:A10),2)
Then you just convert the formula to a constant.
Biff
> Hi.
> I am trying to contain a number value in excel after changing the value
[quoted text clipped - 5 lines]
> number value is displayed with 3 digits. Does that make sense? Please
> help!
jazzydwit - 29 Dec 2005 03:17 GMT
hi.
sorry, just getting back! i will try this to see if it works. thanks!