|
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! |
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! |
| All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com