Removing digits after decimal in "text" numbers

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

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What function do I use to calculate a Sum of Digits? 3
Calculating a Check Digit Routine 4
Cell reference in formula string displays abbreviated value 2
Lookup against concatenated source value 2
omit numbers past decimal in formula result 6
Number of days 2
sum numbers in cell string array 6
counting digits, not numbers 4

Top