| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to column
The MID function is a text function and will leave the "numbers" as text.
I don't know what MID formula you used, but you could probably add a *1 which forces the text to numeric. e.g. =MID(H3,3,2)*1 Gord On Tue, 9 Dec 2008 05:56:35 -0800, ChewinFoil wrote: I already tried SUM on range but result is zero. But I was using the MID function solely, I'll try Chip's code instead, thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to subtract one text column based on their text column MS xls. | Excel Discussion (Misc queries) | |||
| Find a text from a column in a text string within another column? | New Users to Excel | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
Threaded Mode
