Decrease Decimals In "TRIM"

[Kolin]

Hey guys,

Quick question for today.

I'm using the "TRIM" command to grab statistical data, and was wondering how I can lower the amount of decimals that return from the data.

For example, when I have the following in my cell:

=TRIM("we had "&D16&" Divine claims which is a decrease of "&E16*100&"%")

It returns me:

we had -1723 Divine claims which is a decrease of -20.5878838570916%

What I want it to return is:

we had -1723 Divine claims which is a decrase of -20.59%


Thanks in advance!

[NBVC]

Perhaps...

=TRIM("we had "&D16&" Divine claims which is a decrease of "&ROUND(E16*100,2)&"%")

[Kolin]

Excellent! Thank you, works perfect

[Marcol]

Try this

Please Login or Register  to view this content.

Hope this helps

{EDIT]
To late Again!