formatting number value to text value in excel
 

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!

formatting number value to text value in excel
 

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

"jazzydwit" wrote in message
oups.com...
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!

formatting number value to text value in excel
 

hi.
sorry, just getting back! i will try this to see if it works. thanks!