Forum Discussion
Excel FIELDVALUE function
If data is in table and we use FIELDVALUE() Excel automatically converts text to most close from its point of view data type, and if only nothing is close opens data selector.
For example, having
with applying Stock data type we have
If we see that something is converted wrongly, we may right click on data type and initiate data selector by
Here change name if necessary and select correct data type
Finally
Automatic conversion is applied by default for bulk conversion (i.e. for column in table or for the range). If try to convert text in separate cell, default will be Data Selector.
I'm not sure if we may change such behaviour.
SergeiBaklan Sergei, Thank you for responding, especially at 4:42 am. Your suggestion works. VTV is now correct in my table. If you did not know the precise text to put in column 1, then the function will fail (as I did). How did you know about the need for the semicolon and space? See below the best description available from my broker's website for GFOF. The function fails even when I add the semicolon before ETF. Again, thanks for helping.
SN_SN , you are welcome.
In such cases I play with the text in separate cell, not in table or range. Data selector gives more options.