If number is negative, HEX2BIN ignores places and returns a 10-character binary number. If number is negative, it cannot be less than FFFFFFFE00, and if number is positive, it cannot be greater than 1FF.

To run a Control Panel tool in Windows, type the appropriate command in the Open box or at a command prompt. NOTE: If you want to run a command from a command prompt, you must do so from the Windows folder.

Returns the values from "quantity" along with hexadecimal value of all the data values in the column "quantity" and displays the results in the column "HexValue". Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module.

If number is negative, BIN2HEX ignores places and returns a 10-character hexadecimal number. If BIN2HEX requires more than places characters, it returns the #NUM! error value.

If you select two columns of numbers, rather than one of numbers and one of corresponding text categories, Excel will chart your data in bins, just like a histogram.

Converts decimal 9 to binary with 4 characters. The DEC2BIN function converts a decimal number to binary.

Regsvr32 is a command-line utility to register and unregister OLE controls, such as DLLs and ActiveX controls in the Windows Registry. Regsvr32.exe is installed in the %systemroot%\System32 folder in Windows XP and later versions of Windows. The 64-bit version is %systemroot%\System32\regsvr32.exe.

If you receive a message that states, "Text marked in red will not save correctly in the chosen encoding," you can try to choose a different encoding, or you can select the Allow character substitution check box.

To create a histogram in Excel, you provide two types of data — the data that you want to analyze, and the bin numbers that represent the intervals by which you want to measure the frequency.

This article describes the formula syntax and usage of the CHAR function, which returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.