text to column deletes initial 0s
Posted by alan on February 15, 2002 1:56 PM
if i have the following text:
alan 033
and i do a text to column on it, i always lose the 0, even if the column is preformatted with "text" Any way around this?
Posted by Dreamboat on February 15, 2002 2:00 PM
Not simply. Not without reformatting the column, i.e., Format-Cells, Custom and type in 000000 for a six-digit account number, or choose Special and zip code for a zip code.
Posted by Mark W. on February 15, 2002 2:21 PM
Not so...
Apply the "Text" Column data format to the column
containing 033 (at Step 3 of 3 of the Text to
Column wizard) BEFORE you press the [ Finish ]
button.
Posted by Mark W. on February 15, 2002 2:23 PM
33 (formatted as 000) isn't the same as "033" [nt]
Posted by Jack in the UK on February 15, 2002 2:35 PM
Carfeul not always what you see Excel sees the same, poss faulty in calculations [NT]
Posted by Mark w. on February 15, 2002 2:51 PM
I'm always careful Jack : ) [nt]
