Posted to microsoft.public.excel.programming

Max Scott[_2_] Max Scott[_2_] is offline

external usenet poster

Posts: 1

Importing Data - overriding auto format

I am importing CSV files using a macro. In one column I have data that looks like dates - eg 10-12, 11-09 etc which Excel automtically thinks this is a date and puts Oct-12 or Nov-09 (or their numerical equivalent to be precise) into the cell. Can I override this and tell excel (in VB) that column 1 is text not date

Thanks

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
Importing data from another spreadsheet to a different format	Cam Buskell	Excel Discussion (Misc queries)	0	July 3rd 08 10:10 PM
conditional format overriding border	Teresa	Excel Discussion (Misc queries)	0	April 30th 08 05:08 PM
cell format options when importing data	t_coop	Excel Discussion (Misc queries)	2	April 7th 08 03:12 PM
New Conditional Format Overriding Previous Conditional Format	Rene	Excel Discussion (Misc queries)	3	February 27th 08 06:08 PM
Auto Importing of text fiel data	Mike Nettleingham	Excel Programming	0	September 16th 03 12:19 AM

All times are GMT +1. The time now is 03:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us