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


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=554231

Removing digits after decimal in "text" numbers
 

="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"
wrote in message
...

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

Removing digits after decimal in "text" numbers
 

"jermsalerms"
wrote in message
...

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

Removing digits after decimal in "text" numbers
 

works great. Thank you.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=554231