software

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 muchChoose Text for that field--not General.

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

Aaron wrote:
gt;
gt; Hello,
gt;
gt; I have some data that needs to be parsed...like this:
gt;
gt; Z:\02\ALPHA\0025.txt
gt;
gt; I'm trying to text to columns fixed width in order to get the 0025 number.
gt; When I do this, the number turns into 25 rather than 0025. Any ideas on how
gt; to keep the zeros on there? Thanks much

--

Dave Peterson