| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
convert text to number format
Hello,
I have a column of numbers that have the comment "The number in this cell is formatted as text or preceded by an apostrophe". I'd like to convert all these these values to numbers so I can get a summation. By mousing over the cell I can get a menu that allows me to convert the numbers one at a time, but how can I convert them all at once? I've tried converting with the Format/Cells and Edit/Copy/PasteSpecial/values. Thanks in advance, Ellen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| What defines number or text | New Users to Excel | |||
| convert number into corrseponding text | Excel Discussion (Misc queries) | |||
Threaded Mode
