Displaying currency as 2 decimals as part of a larger text

  • Thread starter Thread starter Hari Prasadh
  • Start date Start date
H

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
 
="The discount given was - $" &text(A1,"#,##0.00")
or maybe
="The discount given was - " &text(A1,"$#,##0.00")
 
Thanks a lot Dave. It works

Dave Peterson said:
="The discount given was - $" &text(A1,"#,##0.00")
or maybe
="The discount given was - " &text(A1,"$#,##0.00")
Click to expand...
 
Back
Top