formating within formula

[thrava]

Hi group.

In C10 cell I have the following formula:

="The total percentage is " & A10
Cell A10 is a percentage calculation. The problem I have
is that in Cell C10, the display is something like this:

The total percentage is 0.63447676223746
I know that if this value was a currency, I could have
used the formula ="the total percentage is " & dollar(A10).
This would have gotten rid of extra decimals. What other
formating can I use to only keep two digit in this
percentage within the formula?

Any help is appreciated
Thanks

 

[Frank Kabel]

Hi
try
="The total percentage is " & TEXT(A10,"0.00%")

 

[Alan]

="The Total Percentage is "&ROUND(A10,2)
Regards,

 

[thrava]

Awesome,
Where Do I find this type of information? I wasn't able to
find in the online help.

 

[Thrava]

Thank you this works as well.
I appreciate your time and help.

Can you tell me where I could find formatting commands
like this? I mean I couldn't find this in the online help.

Thanks

 

[Alan]

Its all in the Excel Help files, hit F1 and ask a question,
Try this one too,
http://homepage.ntlworld.com/noneley/
It talks a bit plainer than Help does at times,
Regards,