Removing digits after decimal in "text" numbers

  • Thread starter Thread starter jermsalerms
  • Start date Start date
J

jermsalerms

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 character
two places after the ".
 
"jermsalerms" <[email protected]>
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 "."
Click to expand...

=CONCATENATE("Your payment is $",TEXT(A1,"0.00"),"and is due in 15 days.")
 
Back
Top