Custom data types

Traditional Excel has only two data types: text and numbers. All others (date, time, percentage, etc.) are specially formatted numbers. In the second half of 2019, Microsoft added new data types to Excel: Geography and Stocks. First, for a given term, offers an abundance of geographical determinants while the second provides data on stock market. A lot of new types have been announced, and since recently users of Microsoft 365 subscriptions can create custom data types.

Geography & Stocks

Excel has not changed essentially from its origin, and one of its features is that it does not have data types other than text and numbers. All other (derived) types are only differently formatted numbers. In this respect, Excel 2019 (O365) brings two new types: Stocks and Geography. Since it is unlikely that any of you will be trading on stock exchange, this “recipe” will most of the time deal with geographical data and their application.