Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula snafu
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbars macro buttons snafu | Excel Discussion (Misc queries) | |||
sumproduct snafu | Excel Discussion (Misc queries) | |||
sumproduct snafu | Excel Discussion (Misc queries) |