| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to loose all numbers after decimal (not rounding) | Excel Worksheet Functions | |||
| removing spaces between the numbers | Excel Discussion (Misc queries) | |||
| all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| Removing the ' before numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
