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.
Thank you for your prompt response. That image is what I would expect to see. But no such option appeared on screen. The result "VTV Therapeutics" with no further options. How did you "force" it to present options? Is there a setting somewhere?
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.
- Excellent! Thank you. My issue is completely resolved.