| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
changing cell values with text and currency
You can transform text "$30.00 USD" to number 30.00 with this formula in a
new column, say enter in B1 =SUBSTITUTE(SUBSTITUTE(A1,"$","")," USD","") Then you can sum column B. Regards, Stefi €˛Leah.girl€¯ ezt Ć*rta: 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 |
| Reply |
| 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 | |||
Linear Mode
