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 |
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 |