“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.”
Windows Intelligence In Your Inbox
Sign up for our new free newsletter to get three time-saving tips each Friday — and get free copies of Paul Thurrott’s Windows 11 and Windows 10 Field Guides (normally $9.99) as a special welcome gift!
“*” indicates required fields
Microsoft is adding a feature called value tokens to Excel that will better differentiate rich data types in the formula bar. With this change, rich data types will be visually called out with a colored background and accompanying icon, providing “a clear visual indication that a cell contains a data type or other richer formats.”