| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Text String: Formatting Text and Numbers?
Excel 2003
If I havea text string formula and I insert a number. How do I get the number to be formated with the comma for "thousands" [A1] = "I want to purchase " &C2& " candy bars from the grocery store" = "I want to purchase " 10,000 " candy bars from the grocery store" I tried TEXT(A1,#,###) and doesnt work Also, I want to put only a couple of words in bold font?. For example the word "purchase". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pull numbers from text string | Excel Discussion (Misc queries) | |||
| Extracting numbers from string of text | Excel Discussion (Misc queries) | |||
| combining text and numbers in a string | Excel Worksheet Functions | |||
| extracting numbers within text string! | Excel Worksheet Functions | |||
| EXTRACT NUMBERS FROM TEXT STRING | Excel Worksheet Functions | |||
Threaded Mode
