Posted to microsoft.public.excel.programming

avi[_2_]

external usenet poster

Posts: 15

Format number as text on multiple files import to a Single Workbook

Hello,
I want to Import Multiple Files to a Single Workbook and there is code
on http://excel.tips.net/Pages/T003148_...orkb ook.html
that does the job with one exception:

I want all the imported data to be formated as text and not general (I
need leading zeros etc...).
What to add to that code & where ? TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import multiple csv files in single excel file automaticall	D Joshi	Excel Programming	1	March 17th 08 03:27 PM
import multiple text files into single sheet separate column	Jootje	Excel Programming	10	February 8th 08 05:09 PM
Import of Multiple Text Files	yanks6rule[_2_]	Excel Programming	1	January 26th 06 11:34 PM
Import multiple text files into a single worksheet	Scott	Excel Discussion (Misc queries)	0	January 13th 05 10:22 PM
Importing multiple text files into single workbook	Steve[_56_]	Excel Programming	1	January 15th 04 08:18 PM

All times are GMT +1. The time now is 05:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us