| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert text to values
cells have existing values - xls downloaded from a site- numbers come in as text so I can't SUM(x:x) etc. first guess to solve: loop thru entries, save value-convert string to float, reformat cell, replace value? easier idea? Thanks Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I take a string of text and convert it ASCII Values? | Excel Discussion (Misc queries) | |||
| convert to values numbers as text | Excel Programming | |||
| How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
| Convert range of text to values | Excel Programming | |||
Threaded Mode
