You must highlight each column in turn (by clicking on it) and then
select Text. Do this for each column that you want to treat this way.

Hope this helps.

Pete

On Apr 23, 5:32 pm, Rene'''' wrote:
I have tried selecting text in the 3rd step of the text to columns but still
drops the preceding zeros. No one at my office is able to help.



"RagDyeR" wrote:
Are you using the results as numbers, or text?

If text, in the 3rd step of the wizard, select the column with these values,
and then click on "Text" under <Column Data Format.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Rene''" wrote in message
...
I am doing a text to columns function using fixed width. Once this is done,
it drops any preceding zeros. Any ideas how to stop dropping the zeros?- Hide quoted text -

- Show quoted text -