It is possible to get a cell to display one thing, but store another.
Create a Custom Format by right-clicking the cell, select Format Cells…, then from the Number tab select Custom.
In the Type box use whatever text you want displayed, but be sure to enclose it in “double-quotes”. I admit, this is a pretty dirty trick, [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/10/12/numbers-in-disguise/
Posted
Oct 13 2009, 01:59 AM
by
Daily Dose of Excel