The question posted by a new Excel user hits on something most spreadsheet veterans have learned the hard way: formulas return values, and those values have types, but the software itself gives you almost no help telling them apart. This user wants to see that VLOOKUP returns "any" type while CONCAT returns a string. That desire is not a minor curiosity. It is a legitimate request for transparency in a tool that has, for decades, hidden its internal logic behind a wall of cells.
What this user is really asking for is a way to see the data structure behind the number or text that appears in a cell. In traditional spreadsheets, a cell shows you the result of a formula, but it never tells you whether that result is a number formatted as text, a date stored as a serial number, or a lookup that silently returned an error. This opacity is one of the biggest sources of frustration for anyone moving beyond basic data entry. You write a formula, you get a result, but you have no way to confirm that the result is actually the type of data you need for the next step in your workflow.
The practical consequence is wasted time. Users end up manually inspecting cells, running helper formulas like TYPE() or ISTEXT(), or simply guessing and hoping downstream calculations don't break. That is not a workflow problem. It is a design problem. A spreadsheet that cannot show you what its own formulas produce is a tool that forces you to trust it blindly. And trust without visibility is not trust at all, it is a gamble.
This is where an AI-native approach changes the equation. Imagine a spreadsheet that, when you hover over a formula, shows you not just the result but the type, the structure, and even a sample of what that type looks like in practice. That is not a futuristic wish. It is a natural extension of making data transparent rather than opaque. The user who asked this question is not asking for more features. They are asking for clarity. And clarity is exactly what a spreadsheet should provide, because every decision you make in a spreadsheet depends on understanding what the data actually is, not just what it looks like.