Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas!
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas!
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 "Barbara" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas!
Hi Ron,
Thank you very much for your prompt answer. It worked just fine. Barbara "Ron Coderre" escreveu: 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 "Barbara" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
Formulas | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Need help with formulas | Excel Worksheet Functions |