| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing comma in data string
I have a string of numbers, but they've been entered as:
357,041 332,224 341,038 etc. Basically I'd just like to convert them to numbers so I can add, subtract, etc. The problem is that as they are right now, they are stored as text, and I can't figure out how to fix that (format cells number does nothing). Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using comma inside the comma delimited text in Data Validation/Sou | Excel Programming | |||
| removing comma | Excel Worksheet Functions | |||
| Removing a space after a comma | New Users to Excel | |||
| Removing every second instance of comma sign | Excel Programming | |||
| Data string ends up in first cell instead of Comma sepaerated CSV format | Excel Programming | |||
Threaded Mode
