I believe that it is EBCIDIC.

"Chip Pearson" wrote:

> A space character is 32 or hex 20, not hex 40. Are you sure your
> mainframe file is ASCII text (not EBCIDIC)?
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Brad" <Brad@discussions.microsoft.com> wrote in message
> news:9F93CE96-4E08-40BE-A3F1-290D69EBCF66@microsoft.com...
> > When I upload the string from excel to the mainframe and look
> > at the hex
> > representation of the space I get the value of "40"
> >
> > "JE McGimpsey" wrote:
> >
> >> Not sure what you mean, exactly - how did you get your value
> >> of "40"?
> >>
> >> =DEC2HEX(0,2)
> >>
> >> will return "00"
> >>
> >>
> >>
> >>
> >>
> >> In article
> >> <E7BF9B9A-7AF9-4DBA-8614-91B2F02A43A1@microsoft.com>,
> >> "Brad" <Brad@discussions.microsoft.com> wrote:
> >>
> >> > Can a string be built that contains a field with a hex value
> >> > of "00" - spaces
> >> > give a value of "40".
> >>
>
>
>