Thread: Format number as text on multiple files import to a Single Workbook
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
avi[_2_] avi[_2_] is offline
external usenet poster
  
Posts: 15
Default Format number as text on multiple files import to a SingleWorkboo
Well thanx Mike for your effort but
unfortunately it appears not to be working:
"Subscript out of range" error ; does not import all the selected
files into one workbook but only 2 of the selected & into 2 workbooks
one of which has cells format as text but still I have lost my leading
zeros.
Reply With QuoteReply With Quote