←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

"Show Convert to Data Types when typing" function doesn't work

I was playing with Excel Options and there was one checkbox in Options - General - User Interface Options - "Show Convert to Data Types when typing".

I enabled it and tried to test this by typing some data in cells, but for some reason Excel doesn't offer suggestions on data types to convert to.

These are the entries I tried in the cells -

  • "Brazil"
  • "MSFT"
  • "Tokyo"

Is there something else I need to switch on to make this work? Thanks in advance.

submitted by /u/Soundwave707
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#Excel
#Convert to Data Types
#data types
#Options
#User Interface Options
#checkbox
#suggestions
#typing
#cells
#Brazil