View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
donna13pa donna13pa is offline
external usenet poster
 
Posts: 1
Default specify data size in cell add 0's

I want to specify that if data I am importing is 5556946581 it will return as
0000005556946580. It will add 0's to the beginning to make the length 16
characters long and also change the last number to 0 if it is a number from
1-9