Hex low values

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

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

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

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