Text and Numbers

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

My cell contains the data *98. I want another cell to recognize this as the
number 98. Any suggestions ?
 
This formula will work for the example you gave. HTH Otto
=--RIGHT(A1,2)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function that can differentiate between text & numbers??? 6
Text & Numbers 1
Red cell for negative numbers in Excel 1
problem with fractions to decimal 1
sequential text and numbers problem 3
Excel Sum numbers in cells that also contain text 34
Custom Number Format for text 8
Count only cells ending with decimal value of .98 4

Back
Top