Return Two Decimal Places In Text String

  • 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

  • Re: Return Two Decimal Places In Text String


    Beat me to it, shg. ;) 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!