Displaying currency as 2 decimals as part of a larger text

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
 
D

Dave Peterson

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

Hari Prasadh

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
Stop Rounding Currency 20
pivot table loosing decimals (vba) 1
Automatically chnage number format of a range of cells 2
Extracting a Part of a Formula as Text 5
Finetune formula to get currency format? 1
Currency format with 2 decimals not showing on report 2
3 challenges; concequences of activating cell + 2 text formulaproblems 2

Top