Concantenate and keep trailing zeros of dollar field

[karstens]

Since concantenate combines fields and lists them as text, when my dollar values have trailing zeros, it drops them.
Is there a way to add to my formula to tell it not to drop those zeros?

Here is the formula I am currently using:
G2=1000.10
G3=Test
=IF(G2="","",CONCATENATE("$",G2," ",H2))
Results are: $1000.1 Test

I would like it to say $1,000.10 Test

It would be helpful if the comma could be added as well when it is hits four decimals, but it drops that as well. If I can't get that back, I would be ok with it as long as I can get the trailing zero.

Thanks for your help.

[benishiryo]

hi karstens, you mentioned "Test" in G3 but formula combining with H2? i'm assuming it in H2, then:
=IF(G2="","",CONCATENATE(DOLLAR(G2,2)," ",H2))

or:
=IF(G2="","",DOLLAR(G2,2)&" "&H2)

[popipipo]

Change 'G2' into 'TEXT(G2;"0000,00")'

[karstens]

Awesome bebishiryo!
That is exactly what I needed! Thank you so much!