Check to make sure each company converted correctly. The stock ticker symbols will change to the official name of the company along with an icon with Roman columns in front of a building. The stocks icon is likely in English on your computer Select just the cells containing stock symbols and use Data, Stocks as shown below.
Format the data as a Table using either Home, Format as Table or Ctrl + T. To start, type a series of stock symbols in a column in Excel.
This feature is only available to people with an Office 365 subscription - it will never be included if you purchase Excel 2019, or Excel 2016 or Excel 2013.
While I covered geography data types on Monday, today is a discussion of stock data types. Microsoft is adding Stock and Geography data types to Excel.
