Forum Discussion
'Else part' of if() is executed even if the condition mentioned is true.
Column f is formatted as general not text SergeiBaklan
It could be formatted as General, but MID() returns texts, thus values are considered as texts. You may check by ISTEXT() on cell from any empty one.
- I have a doubt that how text format can be shown as general format in excel. Excel should show text format instead of general.
Format and type of the value are different things. If you apply General format to the cell which has Text value, you don't convert the value itself from one type to another, you need to reenter it.
Same if you return value by any formula. Returned value will be shown in the format already applied to the cell, formula result wont change any property of the cell, includes applied format.
If cell is under General format returned value will be shown as text or number depends on what formula returns. Simplest way to check - by default text is aligned to the left, and number to the right.
Here MID() from text always returns text and it is shown as text. If text represents number it may be converted to number within arithmetic operation, result will be number. Thus you may multiply such text on 1; or add zero; or apply two times negation (aka "double dash") to convert such text to number.