FAQ-975 How do I use hexadecimal values in my data sheet?

Transpose-column-to-row

Last Update: 10/1/2018

Beginning with Origin 2019, Origin supports direct display and manipulation of hexadecimal values in the worksheet. In previous versions, hex strings had to be converted to numerics using the Hex() or Hex2Dec () functions , operated on, then converted back to hex strings using Dec2Hex().

• Hex values can be manipulated directly in the worksheet using functions like BitAND() and BitOR() and the Set Values dialog box.
• The worksheet supports custom display of numerics in common hexadecimal formats.

For more information on displaying hexadecimal values in the worksheet, see the OriginLab blog post Custom Formats of Numeric Display in a Worksheet or a Graph.

Keywords:custom format, worksheet, bit, bitwise, Hex, Hex2Dec, Dec2Hex, BitAnd, BitOr, BitXor, BitLShift, BitRShift