Used input function and text but unable to format the number (amt)

[Muhammad1122]

I am using the input function to make it easier to prepare documents, but i have a problem when it comes to format the amount as X,XXX.XX, The commas disappear and i dont have a clue from where i can make it look like USD x,xxx.xx , If i dont use text in the cell then i could normally format as i want, but when there is text, for example ="US $ "&INPUT!$C$15 i am unable to format the input which is a number to thousand separator commas and the two digits of cents after it.
in more than one occasion i have to use text before and after the input function but at the same time I want the input (amount) formatting to be as X,XXX.00, The separators are important.
I have attached the file explaining the problem.

thank you and appreciate your help

[AliGW]

Welcome to the forum.

Try this:

="US $ "&TEXT(INPUT!$C$15,"0,000.00")

[AliGW]

Or, without the formula, custom cell formatting:

"US "_-[$$-en-US]* #,##0.00_ ;_-[$$-en-US]* -#,##0.00 ;_-[$$-en-US]* "-"??_ ;_-@_

Change the cell to this:

=INPUT!$C$15

[Muhammad1122]

Thank you very much, it worked

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.