Text function& concatenate

[Ufoo]

Hello, suppose I want $25,000 to be $25,000 paid. I will use this formula: =TEXT(G4,"$ #,###,###")&" paid". But this formula does not work with the currency of my country, whose symbol in excel is TZS. Please help. Thanks

 

[NARAYANK991]

Hi ,

Does this not work ?

="TZS" & TEXT(G4," #,###,###") & " paid"

Narayan

 

[bosco_yip]

Maybe,

=TEXT(G4,"#,###,###\/=")&" paid"

Regards

 

[Ufoo]

Hi ,

Does this not work ?

="TZS" & TEXT(G4," #,###,###") & " paid"

Narayan

Yes it does. Ingenious. I should have figured that out. Thanks a lot.

 

[Hui]

or
=TEXT(G4,"\T\Z\S #,###,### \P\a\i\d")
or
=TEXT(G4,"""TZS"" #,###,### ""Paid""")

Best Method
Actually the best method would be to use a Custom Number Format
Select the cell
Ctrl+1
Number, Custom
enter "TZS" #,###,### "Paid"

Apply

Using this the cell still contains the value and can be used in subsequent formulas, where as the Text() functions converts the number to unusable text

 

[Ufoo]

Maybe,

=TEXT(G4,"#,###,###\/=")&" paid"

Regards

This works too. Thanks

 

[Ufoo]

Maybe,

=TEXT(G4,"#,###,###\/=")&" paid"

Regards

Thanks. I am wondering what backslash (\) does in the formula??

 

[Hui]

The Backslash allows the next character to be interpreted as text and not a special character