add a formula to Excel

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

Guest

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
 

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

Scrabble Value calculation for Welsh words 0
convert figures into words on Microsft Excel 3
Convert time to text 3
copy data while skipping a predetermined number of cells 5
Conversion from Number to Word!! Aki 1
Currency to Text 1
Loop for VBA code? 5
I need BIG help with with formula 2

Back
Top