On May 9, 2:16 pm, Delimiting and Formatting <Delimiting and
wrote:
I am trying to delimit a string of data, which contains, in one column, a
series of six digits which start with the number zero. After typing the
number in the zero is remove, i.e. I enter 001234 then becomes 1234. Is it
possible for the zero(s) to remain a part of the entry? PLEASE HELP!

Format the cell as "000000". FormatCells, Number tab, select Custom
and specify 000000.