Thread: number format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default 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