number format
 

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

number format
 

Choose Text for that field--not General.

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

Aaron wrote:

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