Text and Numbers

M

Mike

My cell contains the data *98. I want another cell to recognize this as the
number 98. Any suggestions ?
 
S

Shane Devenshire

Hi,

LEFT returns text, so instead you can write either

=--RIGHT(A1,2)
or
=--SUBSTITUTE(A1,"*","")

You start both of these with 2 minus signs.

By the way the RIGHT function is set to work only for 3 digit entries, you
could generalize if
=--RIGHT(A1,LEN(A1)-1)

If these help, please click the Yes button.

Cheers,
Shane Devenshire
 
Top