| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to Add $ and/or commas
Hi,
I have a column of amounts 5000 75 750 10000 and would like them to be $5,000 $75 $750 $10,000 I can't use format cells, because I actually want to add the $ and commas, not just change their format for a merge into word. Any help would be greatly appreciated! Bryce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add commas to the result of a formula with a text operator? | Excel Discussion (Misc queries) | |||
| Help! I need a formula to add numbers separated by commas within | Excel Worksheet Functions | |||
| formula to count commas | Excel Discussion (Misc queries) | |||
| So many commas | Excel Worksheet Functions | |||
| how o i use commas for lakhs | Excel Worksheet Functions | |||
Threaded Mode
