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

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.

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

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

Pete

On Nov 16, 1:56 pm, rdfred wrote:
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.

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

Use the mainframe to convert to IEEE notation.
Or if the program is COBOL get the data out as strings (text)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"rdfred" wrote in message
...
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.

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

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.

"rdfred" wrote:

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.