Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add a formula to Excel
I have the code for converting mainframe numeric data to a real number. I am
having trouble using the code. Can any one please help me? data looks like this: 0000007288D 0000007288M 0000007288D 0000024553{ I must convert the last digit to a number in the format (abbreviated): Case "E" : i = 5 Case "F" : i = 6 Case "G" : i = 7 Case "H" : i = 8 Case "I" : i = 9 Case "}" : i = 0 sign = -1 Case "J" : i = 1 sign = -1 Case "K" : i = 2 sign = -1 Case "L" : i = 3 sign = -1 Thanks for youir help -- Arbert Only dead fish go with the flow! |
#2
|
|||
|
|||
What is M??
-- Gary's Student "arbert" wrote: I have the code for converting mainframe numeric data to a real number. I am having trouble using the code. Can any one please help me? data looks like this: 0000007288D 0000007288M 0000007288D 0000024553{ I must convert the last digit to a number in the format (abbreviated): Case "E" : i = 5 Case "F" : i = 6 Case "G" : i = 7 Case "H" : i = 8 Case "I" : i = 9 Case "}" : i = 0 sign = -1 Case "J" : i = 1 sign = -1 Case "K" : i = 2 sign = -1 Case "L" : i = 3 sign = -1 Thanks for youir help -- Arbert Only dead fish go with the flow! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |