Displaying currency as 2 decimals as part of a larger text

[Hari Prasadh]

Hi,

I have the value 2.00 in Cell A1 with formatting as $ Currency

In cell A2 I have a formula = "The discount given was - $" & A1

The display I get in A2 is "The discount given was - $2"

The trailing decimal zeroes get truncated in display. How to overcome the
same?

On the other hand...if I had the value 2.04 in cell A1 then the decimal
display in A2 does NOT get truncated.

Pls suggest a solution.

Thanks,
Hari

 

[Dave Peterson]

="The discount given was - $" &text(A1,"#,##0.00")
or maybe
="The discount given was - " &text(A1,"$#,##0.00")

 

[Hari Prasadh]

Thanks a lot Dave. It works

="The discount given was - $" &text(A1,"#,##0.00")
or maybe
="The discount given was - " &text(A1,"$#,##0.00")