| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to get original cell value from a "number stored as text"
Unfortunately we can not loop through each cell, as these worksheets are very large. We are sucking out the data in bulk. Calliing a function each time would be very time consuming. When looping through each cell in a worksheet, extraction of the data takes over 2-3 minutes on a very fast box.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| Pasted values that paste as "number stored as text" | Excel Discussion (Misc queries) | |||
| Text stored in a cell is displayed as a string of "#####..." | Excel Discussion (Misc queries) | |||
| EXCEL - unable to get "TEXT" to wrap, even though cell is formatte | Excel Worksheet Functions | |||
| How do I ignore the "Number stored as text" error message permane. | Excel Discussion (Misc queries) | |||
Hybrid Mode
