how do you return two decimal places in a text string in a cell. for example --this is the value i have in call A1 formatted for currency A1=$12.30 cell A2="I want to pay"&A1 but this returns "I want to pay 12.3" How do i make it say 12.30?
Thanks for the help
I would just add a note as to why it is necessary. The formatting in cell A1 refers only to cell A1's look. When you take the value from A1 and use it in A2, that format is lost and you have to re-format to get the look back.