Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Mainframe DISPLAY data to EXCEL formats
I am doing more FTPs from our mainframe into EXCEL. One problem I struggle
with is the mainframe numbers are formatted in DISPLAY where the last byte of the number contains a sign character (+ 0 = {, +7 = G, -7 = P...). I can write a program on the mainframe to convert the number and place a sign before the data but that increases the size of the field by one byte and also must now be saved as Alpha/Numeric as a minus sign is not a valid numeric value. Ideally a function in EXCEL can be created to accept the DISPLAY format and convert it to a signed, numeric value in EXCEL. Any hints? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Mainframe DISPLAY data to EXCEL formats
Any hints,
Sub FixIt() Dim rngCell As Excel.Range Set rngCell = ActiveSheet.Range("B6") rngCell.Value = CDbl(rngCell.Value) Set rngCell = Nothing End Sub Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Peter" wrote in message I am doing more FTPs from our mainframe into EXCEL. One problem I struggle with is the mainframe numbers are formatted in DISPLAY where the last byte of the number contains a sign character (+ 0 = {, +7 = G, -7 = P...). I can write a program on the mainframe to convert the number and place a sign before the data but that increases the size of the field by one byte and also must now be saved as Alpha/Numeric as a minus sign is not a valid numeric value. Ideally a function in EXCEL can be created to accept the DISPLAY format and convert it to a signed, numeric value in EXCEL. Any hints? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting works data files to excel with original formats | New Users to Excel | |||
converting excel 2003 to 2007 file formats | Excel Discussion (Misc queries) | |||
Converting time formats in Excel | Excel Discussion (Misc queries) | |||
Automate extraction of data from mainframe report into spreadsheet | Excel Discussion (Misc queries) | |||
how to display mainframe negative numbers on excel | Excel Worksheet Functions |