ExcelBanter - view value instead of formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - view value instead of formula (https://www.excelbanter.com/excel-worksheet-functions/112844-view-value-instead-formula.html)

tina

view value instead of formula

Sometimes the formula displays in the cell instead of the value. How do I
get the cell to always show the value? I've tried the Ctrl + ` combination
but this doesn't seem to help in some of my spreadsheet. Is this a setting
I'm missing?

Thanks!!
--
Tina

SteveW

view value instead of formula

Keep to one post, Neik has an answer in the other one.

Steve

On Wed, 04 Oct 2006 13:57:01 +0100, Tina
wrote:

Sometimes the formula displays in the cell instead of the value. How do
I
get the cell to always show the value? I've tried the Ctrl + `
combination
but this doesn't seem to help in some of my spreadsheet. Is this a
setting
I'm missing?

Thanks!!

All times are GMT +1. The time now is 04:07 AM.