Delimiting and Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

Format the cell as "000000". Format>Cells, Number tab, select Custom
and specify 000000.
 
You can either custom number format the cells as 000000 or format the cells
as TEXT or precede the entry with an apostrophe (which also makes it TEXT).
'001234 The apostrophe will not be displayed in the cell.

Using the custom number format of 000000 will *display* the leading 0s but
the *true underlying value* will still be 1234.

Biff

"Delimiting and Formatting" <Delimiting and
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top