After you format as General, try pressing F2 and then Enter.

HTH,
Paul

--

"ScoobyDoo" wrote in message
...
Hi

I cannot get this formula to work:

=IF(ISERR(-TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))),"UNKNOWN",IF(and(--TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))=35,(--TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))<=1859),VALUE(TRIM(RIGHT(SUBSTITUTE(H2,"/",REPT(" ",100)),
100))),"UNKNOWN"))

when I put it into a cell it just shows up as text.

I formatted the cell as General and still nothing

The formula auditor says it is a constant.

the formula is supposed to take text like this:

BGN/17/48

and return the number after the last / character

can anyone help ?

J