Make sure the cell with the formula is not formatted as text, all the
solutions you got will work



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Stephanie" wrote in message
...
I typed in =if right(p4,len(p4)-2). I was not sure what the dashs meant.
However the formula simply sits in the cell. It does not go away and
reflect
an answer. The formula editor continues to state that the value in p4 is
a
constant. All of the step thru etc in the formula editor is grayed out.
I also tried the following solution =IF( LEFT(P4,2)="NW",
VALUE(MID(P4,3,255))). With the same results.. the formula sits in the
cell
with out results

Do the cell contents in P4 need to be changed to something else. I am not
sure why it is calling it a constant. It should read as text.

--
Stephanie


"Gary''s Student" wrote:

=--RIGHT(P4,LEN(P4)-2)

will work
--
Gary's Student


"Stephanie" wrote:

I have cell with NW123456 in p4. I am using the following to remove
the nw.

=if left(p4,2)="NW" or "nw", Value(left(p4)-2)

But it does not work. The formula auditor states I am trying to
evaluate a
constant.

Thank you for any help.
--
Stephanie