Displaying values vs formulas

  • Thread starter Thread starter Gary Vocks
  • Start date Start date
G

Gary Vocks

I'm having another brain-dead moment and I hope someone can resuscitate!
I'm putting formulas in various cells on a worksheet and some of them are
displaying the results and some are just showing in the cell as the formula.
How can I get them all to display results. I swear that all the cells are
formatted the same but the displays are different. What am I doing wrong?
Thanks for any help.

Gary Vocks
 
The cells displaying the formula itself and not the results are probably
formatted as Text.

A quick way to find out if this is so, is to select a cell that displays the
formula, then:
<Ctrl> <Shift> <~>
and then
<F2> <Enter>

What this does is format the selected cell to General,
then edits the cell to register the change.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I'm having another brain-dead moment and I hope someone can resuscitate!
I'm putting formulas in various cells on a worksheet and some of them are
displaying the results and some are just showing in the cell as the formula.
How can I get them all to display results. I swear that all the cells are
formatted the same but the displays are different. What am I doing wrong?
Thanks for any help.

Gary Vocks
 
Back
Top