Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
arbert
 
Posts: n/a
Default 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   Report Post  
Gary's Student
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel CHALLENGE...3 questions(indirect,rank,array formula)... Mlowry Excel Worksheet Functions 8 August 1st 05 07:34 AM
converting formula from lotus.123 to excel zaharah Excel Worksheet Functions 2 July 27th 05 03:04 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
How do I get the formula bar in excel 2003 unionhall Excel Discussion (Misc queries) 1 February 17th 05 10:10 AM
Suddenly Excel can't calculate formula!!! Bob H Excel Worksheet Functions 2 November 30th 04 08:35 PM


All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"