Excel In-Cell Code; limit dollar to two decimal placed

[IGPOD]

Hello,

I'm having difficulty trying to limit the decimal places to 2... the photo attached will show my code and my issue in cell G3; the reading for the dollars is more than 2 spaces. Is there a better code I should be using for this type of output?

 

[etaf]

use TEXT()

So instead of (G2*F3) = Text((G2*F3),"0.00")
OR

Text((G2*F3),"#,##0.00") to get , 1000 seperator

FormulaFindRAte.xlsx
	A	B	C	D
1
2
3	123.45678	fred		fred $ 123.46
Sheet2

Cell Formulas
Range	Formula
D3	D3	=B3&" $ "&TEXT(A3,"0.00")

FormulaFindRAte.xlsx
	A	B	C	D
1
2
3	123.45678	fred		fred $ 123.46
4	124456789.5	fred		fred $ 124,456,789.46
Sheet2

Cell Formulas
Range	Formula
D3:D4	D3	=B3&" $ "&TEXT(A3,"#,##0.00")

 

[IGPOD]

use TEXT()

So instead of (G2*F3) = Text((G2*F3),"0.00")
OR

Text((G2*F3),"#,##0.00") to get , 1000 seperator

FormulaFindRAte.xlsx
	A	B	C	D
1
2
3	123.45678	fred		fred $ 123.46
Sheet2

Cell Formulas
Range	Formula
D3	D3	=B3&" $ "&TEXT(A3,"0.00")

FormulaFindRAte.xlsx
	A	B	C	D
1
2
3	123.45678	fred		fred $ 123.46
4	124456789.5	fred		fred $ 124,456,789.46
Sheet2

Cell Formulas
Range	Formula
D3:D4	D3	=B3&" $ "&TEXT(A3,"#,##0.00")

Thanks for the resolution! I learned yet another tool for my Excel Toolbox.

 

[etaf]

you are welcome