Removing digits after decimal in "text" numbers

Cell A1 contains a formula that returns a number...(ex. 211.56777777)

Cell B1 contains the following formula:
=CONCATENATE("Your payment is $",A1,"and is due in 15 days.")

As the formula stands now the reslult is:
Your Payment is $211.56777777 and is due in 15 days.

I need it to say:
Your Payment is $211.56 and is due in 15 days.

What do I need to add to the formula so that it removes all characters two places after the "."

="Your payment is $"&TEXT(A1,"#,##0.00")&"and is due in 15 days."


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...
>
> Cell A1 contains a formula that returns a number...(ex. 211.56777777)
>
> Cell B1 contains the following formula:
> =CONCATENATE("Your payment is $",A1,"and is due in 15 days.")
>
> As the formula stands now the reslult is:
> Your Payment is $211.56777777 and is due in 15 days.
>
> I need it to say:
> Your Payment is $211.56 and is due in 15 days.
>
> What do I need to add to the formula so that it removes all characters
> two places after the "."
>
>
> --
> jermsalerms
> ------------------------------------------------------------------------
> jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
> View this thread: http://www.excelforum.com/showthread...hreadid=554231
>

"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...
>
> Cell A1 contains a formula that returns a number...(ex. 211.56777777)
>
> Cell B1 contains the following formula:
> =CONCATENATE("Your payment is $",A1,"and is due in 15 days.")
>
> As the formula stands now the reslult is:
> Your Payment is $211.56777777 and is due in 15 days.
>
> I need it to say:
> Your Payment is $211.56 and is due in 15 days.
>
> What do I need to add to the formula so that it removes all characters
> two places after the "."

=CONCATENATE("Your payment is $",TEXT(A1,"0.00"),"and is due in 15 days.")
--
David Biddulph

works great. Thank you.