View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Professor_Higgins[_2_] Professor_Higgins[_2_] is offline
external usenet poster
 
Posts: 3
Default 4-5 digit numbers to display leading zeros totalling 6 digits

I am uploading these numbers to an application
that stores and displays 1543 as 001543.

1543 becomes 001543
17626 becomes 017626

I need to convert all numbers from 1000 to 19000 to show as 001000 to
019000. This column may include some or all of these numbers.

I am trying to avoid converting to text but don't know how to do that either
other than manually. I am really an out of work actor so I require explicit
instructions please.

Thanks a million!