<div>
Can you give an example? Most formulas reference the underlying value in a cell - e.g. for a date the underlying value is a serial number - you only see the date if you format the result cell accordingly.<br />
<br />
regards, barry
</div>


Can you give an example? Most formulas reference the underlying value in a cell - e.g. for a date the underlying value is a serial number - you only see the date if you format the result cell accordingly.

regards, barry

<div>
<div class="content wysiwyg-content">
Is there a way to reference what is visibly shown in a cell and not the number in the cell?
</div>
</div>


Is there a way to reference what is visibly shown in a cell and not the number in the cell?

Reference value as shown

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.