| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to add commas to the result of a formula with a text operator?
="Balance is $"&ROUND(N53,2)&"."
The display is "Balance is $12345678.90." How can I add commas? Formatting the cell to currency doesn't do anything. Workarounds like putting the text in an adjacent cell aren't acceptable here. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Threaded Mode
