Towards the end of the Text to Columns, specify the format of the relevant
columns as text.
--
David Biddulph

"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?