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?