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

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.
 
P

Pete_UK

Can you post some examples of your packed signed data and how you
would like them to be interpreted?

Pete
 
B

Bernard Liengme

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

Guest

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 can I import "Packed" mainframe data into Excel? 9
Packed decimal or computational fields 2
Text Data Fields mixed with binary (Comp) and packed (Comp-3) data 5
Converting Packed Data 2
Is there a simple formula to convert time in hundredths to minute 10
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Is there a function that will evaluate a text string in a cell? 2
VLOOKUP Help!! ASAP!! 2

Top