Formulas!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a field with 9 digits. I used the RIGHT formula to extract 5 numbers
from it. Now I also need to convert it to number (perhaps the VALUE). How can
I join those two formulas?

Example: 310009148 09148 wrong. i need 9148
310010542 10542 10452. ok.

Hope someone can help me.
Thanks,
Barbara
 
Excel needs to be prompted to coerce the "numeric text" into a number.
The standard convention for doing that is the double-minus....(see below)

With
A1: 310009148

Try this
B1: =--RIGHT(A1,5)



Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Hi Ron,
Thank you very much for your prompt answer. It worked just fine.

Barbara

"Ron Coderre" escreveu:
 

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

Need the last 5 numbers in another field 4
Help with troublesome .CSV fields! 3
Extracting 7 digit number from alphanumeric string 10
Compound Formula for Substitution 3
copy formula - keep cell same but increment sheet numbers 5
Help With Formula For Date Comparison 6
Formula error 4
help with formula 1

Back
Top