CONCAT with 2 decimal only

[ARJUNDSOUZA]

Dear Gurus,

Looking to use CONCAT however the result in cell B8 does not give the currency sign of cell B4, further it is more than 2 decimal values. Want the final value to display as cell B10.

Attached is the sample file created to explain the same.

Thanks in advance.

Kind regards

 

[pecoflyer]

Try = TEXT(B4,"#.00")&" "&B6
( I don't have the CONCAT function)

 

[bosco_yip]

Try,

In B8, enter formula, and &" " can be saved, please see :

=TEXT(B4,"$0.00 ")&B6

Regards

 

[ARJUNDSOUZA]

Thank you very much, works perfectly.

 

[Excel Wizard]

or use

=DOLLAR(B4)&" "&B6

 

[Peter Bartholomew]

@Excel Wizard
Interesting. I never before had cause to use the DOLLAR function but, for me, it gives a "£" symbol and not the "$".

If the text element does not change, it would be possible to apply the number format
$0.00 "SUBJECT TO GOVERNMENT TAXES"
directly to cell B4, provided the column width is large enough to accommodate the number length.

 

[Excel Wizard]

The dollar sign refer to Currency symbol in the region setting.
or try="$"&fixed(B4)&" "&B6