CODEWITHSUNDEEP
stringexcelformattingexcel-formulaworksheet-function
methuselah
methuselah

Reputation: 13216

Automatically append given text to the result from a formula

I have the following formula:

=$AF$46

How would I append text to its result?

e.g., if =$AF$46 is showing up as 0.00, how would I make it show 0.00% done?

Editor's note: The question was later extended to "restrict" formatting of the formula's result to 2 decimal places. Some answers predate this requirement; others cover either of the two possible interpretations of "restrict": "up to 2 decimal places" and "exactly 2 decimal places".

Upvotes: 0

Views: 946

Answers (5)

pnuts
pnuts

Reputation: 59495

Maybe just use custom formatting: 

#,##0.00"% done"

(preserves value in case required for further calculation).

Upvotes: 4

Tim Sands
Tim Sands

Reputation: 1068

You could use the TEXT excel function like:

=TEXT(AF46,"#0.00") & "% done"

The second argument '#0.00' to the TEXT function is an Excel format code. This will ensure that Af46 is displayed in the right format. Simply using AF46 in the formula could lead to things like '0.3333333333 % done', rather than formatted to 2 decimals.

Upvotes: 2

KWeiss
KWeiss

Reputation: 9

The easiest way is to use the concatenate function.

=CONCATENATE($AF$46,"% done")

Upvotes: 0

Pops
Pops

Reputation: 498

This can be achieved with the CONCATENATE function

=CONCATENATE($AF$46,"% done")

Upvotes: 1

Netloh
Netloh

Reputation: 4378

You can add text via a formula like the following (if you place this in a different cell than AF46):

=AF46 & "% done"

Upvotes: 2

Related Questions