| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula returned instead of result
from downloaded file, in A1 have CS1234567 and want the numbers only, used
value(mid(a1,2,7)) and instead of 1234567, it returned formula value(mid(a1,2,7)) . formatted the col for number, and general with same formula returned. Also deleted column then added column with same result. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| different values shown when #DIV/0! error is returned as result | Excel Discussion (Misc queries) | |||
| Excel, function, result to be returned in another designated cell | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Value returned from Formula changes with the Date | Excel Worksheet Functions | |||
| Result not being returned | Excel Worksheet Functions | |||
Threaded Mode
