Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hex low values
Can a string be built that contains a field with a hex value of "00" - spaces
give a value of "40". |
#2
|
|||
|
|||
Not sure what you mean, exactly - how did you get your value of "40"?
=DEC2HEX(0,2) will return "00" In article , "Brad" wrote: Can a string be built that contains a field with a hex value of "00" - spaces give a value of "40". |
#3
|
|||
|
|||
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 , "Brad" wrote: Can a string be built that contains a field with a hex value of "00" - spaces give a value of "40". |
#4
|
|||
|
|||
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" wrote in message ... 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 , "Brad" wrote: Can a string be built that contains a field with a hex value of "00" - spaces give a value of "40". |
#5
|
|||
|
|||
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" wrote in message ... 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 , "Brad" wrote: Can a string be built that contains a field with a hex value of "00" - spaces give a value of "40". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Why do old, unused values still show in my Pivot Page fields? | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Save External Link Values | Excel Discussion (Misc queries) |