| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing cell values with text and currency
Hi, I need to add some cells together but they have both text and currency.
example "$30.00 USD" is there anyway to add them with both text and currency. Or anyway to format them to delete the text portion. As it takes me a long time to delete the text hand. Cheers and thanks Leah |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Currency Becomes Text ? | Excel Discussion (Misc queries) | |||
| Cell Format - $ and Text | Excel Worksheet Functions | |||
| Currency to Text | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Formatting a text box to display as currency | Excel Worksheet Functions | |||
Threaded Mode
