number format

[Aaron]

Hello,

I have some data that needs to be parsed...like this:

Z:\02\ALPHA\0025.txt

I'm trying to text to columns fixed width in order to get the 0025 number.
When I do this, the number turns into 25 rather than 0025. Any ideas on how
to keep the zeros on there? Thanks much

 

[Dave Peterson]

Choose Text for that field--not General.

(or format that column with a custom format of 0000)