To answer Rick Rothstein reply; the formula box is not check.

I'm not copying the formula from one cell to another. In my example cell E2
just had the formula manually entered but it does not display the information
from cell D2; it only displays the formula.

I went to a colmn further to the right; column J2 and manually entered the
same formula and it wouldn't show the correct information either.

I had a cell, C2 which contained a name so I placed a formula in K2 that
said "=C2" and the name was displayed. I then retyped the same formula in K2
"=C2" and the name would not display; only the formula I typed in.


"bj" wrote:

other formulas in the same cell work OK?
If you are copying and pasting the formula , select the "=" and replace it
with a new "=".


"El Bee" wrote:

Don.

Here's befo


Column D Column E
1280-28101


Here's After

Column D Column E
1280-28101 =right(D2,4) ( this is what is displayed in the cell E3)
( should display
8101 )





"Don Guillett" wrote:

Before/after examples?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"El Bee" wrote in message
...
I am baffled. I received a challenge to edit the date in one column. It's
a
number that is formatted as a string.
I figured no problem so I entered a formula in an adjacent cell
"=right(D3,4)" and the only thing displayed is the formula (in the cell)!

I tested a different column and got the same thing. So I changed the
formula to point to a cell that had a name in it. The name was then
displayed in the new cell. I then went back to the same cell with the
formula that pointed to the persons name and re-entered the formula and
guess
what, it now only displays the formula and not the persons name.

Is there some security issue I'm dealing with in this spreadsheet if so
how
do I turn it off?