Excel 2000 Formula

[lyn]

Am having a problem with excel in one of the
workstations.At times while working on worksheets when the
user clicks on a cell the formula cant be veiwed on the
formular bar.The sheet is not protected with the hidden
option.This will persist till she reboots the machine
which is running on win2k pro

 

[Raghu Prakash]

Hi Lyn,

Viewing and Reusing a Formula
By default, if you type a formula into a cell, the formula disappears in
favor of its result as soon as you press ENTER or click the green OK
checkmark on the formula bar. This is fine if you want to enter a formula
and see the result, but if you want to keep seeing the formula, you have
two choices: Set your worksheet options to show formulas in cells (and not
show the results, even though they're calculated), or to insert the formula
without the equal sign so that the formula is not performed.

Now, how do you pick which solution to use? Well, it depends on your goals.
If you want to see the formula and not the result so that you can
concentrate on how your worksheet works for now and you want to be able to
see results later, the first option is for you. If, on the other hand, you
want to store a formula in a cell and use it throughout your worksheet as a
functioning formula (with the equal sign), you'll want to follow the second
path

http://www.microsoft.com/learning/books/troubleshooting/excel/ls/070302.asp

Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Raghu Prakash]

Hi Lyn,

Viewing and Reusing a Formula
By default, if you type a formula into a cell, the formula disappears in
favor of its result as soon as you press ENTER or click the green OK
checkmark on the formula bar. This is fine if you want to enter a formula
and see the result, but if you want to keep seeing the formula, you have
two choices: Set your worksheet options to show formulas in cells (and not
show the results, even though they're calculated), or to insert the formula
without the equal sign so that the formula is not performed.

Now, how do you pick which solution to use? Well, it depends on your goals.
If you want to see the formula and not the result so that you can
concentrate on how your worksheet works for now and you want to be able to
see results later, the first option is for you. If, on the other hand, you
want to store a formula in a cell and use it throughout your worksheet as a
functioning formula (with the equal sign), you'll want to follow the second
path

http://www.microsoft.com/learning/books/troubleshooting/excel/ls/070302.asp

Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Raghu Prakash]

Hi Lyn,

Viewing and Reusing a Formula
By default, if you type a formula into a cell, the formula disappears in
favor of its result as soon as you press ENTER or click the green OK
checkmark on the formula bar. This is fine if you want to enter a formula
and see the result, but if you want to keep seeing the formula, you have
two choices: Set your worksheet options to show formulas in cells (and not
show the results, even though they're calculated), or to insert the formula
without the equal sign so that the formula is not performed.

Now, how do you pick which solution to use? Well, it depends on your goals.
If you want to see the formula and not the result so that you can
concentrate on how your worksheet works for now and you want to be able to
see results later, the first option is for you. If, on the other hand, you
want to store a formula in a cell and use it throughout your worksheet as a
functioning formula (with the equal sign), you'll want to follow the second
path

http://www.microsoft.com/learning/books/troubleshooting/excel/ls/070302.asp

Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Raghu Prakash]

Hi Lyn,

Viewing and Reusing a Formula
By default, if you type a formula into a cell, the formula disappears in
favor of its result as soon as you press ENTER or click the green OK
checkmark on the formula bar. This is fine if you want to enter a formula
and see the result, but if you want to keep seeing the formula, you have
two choices: Set your worksheet options to show formulas in cells (and not
show the results, even though they're calculated), or to insert the formula
without the equal sign so that the formula is not performed.

Now, how do you pick which solution to use? Well, it depends on your goals.
If you want to see the formula and not the result so that you can
concentrate on how your worksheet works for now and you want to be able to
see results later, the first option is for you. If, on the other hand, you
want to store a formula in a cell and use it throughout your worksheet as a
functioning formula (with the equal sign), you'll want to follow the second
path

http://www.microsoft.com/learning/books/troubleshooting/excel/ls/070302.asp

Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Raghu Prakash]

Hi Lyn,

Viewing and Reusing a Formula
By default, if you type a formula into a cell, the formula disappears in
favor of its result as soon as you press ENTER or click the green OK
checkmark on the formula bar. This is fine if you want to enter a formula
and see the result, but if you want to keep seeing the formula, you have
two choices: Set your worksheet options to show formulas in cells (and not
show the results, even though they're calculated), or to insert the formula
without the equal sign so that the formula is not performed.

Now, how do you pick which solution to use? Well, it depends on your goals.
If you want to see the formula and not the result so that you can
concentrate on how your worksheet works for now and you want to be able to
see results later, the first option is for you. If, on the other hand, you
want to store a formula in a cell and use it throughout your worksheet as a
functioning formula (with the equal sign), you'll want to follow the second
path

http://www.microsoft.com/learning/books/troubleshooting/excel/ls/070302.asp

Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.