How does one force Excel 2003 to retain leading zeros? This is related to my
earlier messages on "Sorting problem".

One option is to use a number to binary conversion. Each binary number has 8
bits, either 1's of 0's, and all bits are significant so leading 0's must be
retained. The conversion will simply be a lookup table of number and associated
binary equivalent and use the number as a cell reference to get the binary
equivalent.

Another option is to insert leading 0's in numbers that have only 1 or 2 digits
to convert all numbers to 3 digit numbers.

The only way I have thought of is to define the cell as being text rather than a
number.

--

Cheers . . . JC