Thanks:  0
Likes:  0

1. ## CONCATENATE & Percentages

Hi there,

I wish to concatenate a integer and text in one cell.

I wish to convert the integer into a percentage and round it down to 2 decimal places. Here is my current formula:

=CONCATENATE(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100)," % and text")

However, I am left with a number with 10+ decimal places, for example:

332.54545454545

Is there a rule I can apply within the brackets to remove these extra decimal places? Ideally I want to stick with concatenation, as it is very helpful for my project.

I am using Office 2007, Windows XP.

2. ## Re: CONCATENATE & Percentages

use
Code:
`=CONCATENATE(round(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100),2)" % and text")`

3. ## Re: CONCATENATE & Percentages

Originally Posted by MisterBates
use
Code:
`=CONCATENATE(round(((Tabular!E99-Tabular!D99)/ABS(Tabular!D99)*100),2)" % and text")`
That works perfectly - thank you!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•