I am trying to convert a signed packed field in Excel. Is there .

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

Guest

I'm trying to pull mainframe data into an excel spreadsheet, but the data has
packed signed data and I can't seem to find a formula that will do the
conversion. If you know of a way of doing this please help.
 
Can you post some examples of your packed signed data and how you
would like them to be interpreted?

Pete
 
Use the mainframe to convert to IEEE notation.
Or if the program is COBOL get the data out as strings (text)
best wishes
 
Hi,

Hope you are talking about comp-3 data in mainframe. You can write a sort
card in mainframe itself and then convert that value as you want using
editing characters, and then you can download to excel.

Regards,
Soundar.
 

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

How do I get Rid of the Circumflex Accent (Caret) 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
add a formula to Excel 1
Incrementing Formula by Column Instead of by Row 1
Converting standard time to military time 8
Is there a simple formula to convert time in hundredths to minute 10
Can I use an "=" in Excel 2007 cell without making it a function? 2
Excel 2007 paste data, need to convert to numbers 3

Back
Top