nickdirect
New Member
- Joined
- Apr 7, 2006
- Messages
- 5
I have a column of data containing letter and number digits and I am trying to split off part of the number bit (the last few digits). The format of the column is 'text', as is the blank adjacent column to the right of it. I have used the 'text to columns' option to split the data but found that the split off data has all its leading zeros suppressed even though the format of the cell is 'text' and I have told 'text to columns' to treat the data as text. I am using Excel 2003 SP3. How can I fix this problem?
~
Nick
-------------------------
~
Nick
-------------------------