Introducing value tokens in Microsoft Excel

Hey, Microsoft 365 Insiders! I’m Gedion Alemayehu, a Product Manager on the Excel team. I’m very excited to share a new update to the formula editing experience in Microsoft Excel for Windows: value tokens.

Introducing value tokens in Microsoft Excel​

Microsoft Excel has continuously evolved to handle more than just plain text, numbers, and errors. For example, we’ve introduced the ability to put stocks, geography, currencies, and formatted number values, among other data types, in cells, allowing them to hold richer data and connected information.

However, these data types were not able to be shown in the formula bar in a cohesive way – until now! This enhancement provides a clear visual indication that a cell contains a data type or other richer formats. The addition of an icon next to the value further helps differentiate between data types in a spreadsheet.

How it works​

1. Open a new or existing Excel spreadsheet.
2. Select a cell and enter a geography, currency, or another data type.
3. Select Data > Data Types, select the data type you want (e.g., Currencies, Geography), and notice that a value token appears in the cell.
   
   
   

In the future, we plan to more deeply integrate value tokens into Excel’s formula editing experience. We’d love your feedback to make this happen!

Availability​

Value tokens are available to Excel for Windows users running Version 2502 (Build 18623.20020) or later. They will be available in Excel for Mac, Excel for Android and iOS, and Excel for the web soon.

Feedback​

We want to hear from you! To share your thoughts, either select Help > Feedback in Excel or go to the Feedback Portal, and mention value tokens in your response.