Posted to microsoft.public.excel.programming

Andrew Young Andrew Young is offline

external usenet poster

Posts: 1

Opening CSV Files

Does anyone know how I can open a CSV file in Excel and
preserve any leading zeros. I thought that if the values
in the CSV file are wrapped in quotes Excel would treat
them as Strings but it doesn't. Is the only way to do this
is to use OpenText and set the columns to Text?

Thanks,
Andrew

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Opening files	Sandy5590	Excel Discussion (Misc queries)	2	September 8th 09 02:03 PM
show most recent files first when opening excel files	Anne`	Excel Discussion (Misc queries)	5	January 23rd 08 01:54 AM
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20	PoundMutt	Excel Discussion (Misc queries)	1	June 20th 07 03:50 AM
Opening Files	George E	Excel Discussion (Misc queries)	3	September 5th 05 04:12 PM
How can I view files chronologically when opening multiple files	Stevilsize	Excel Discussion (Misc queries)	3	July 26th 05 12:49 AM

All times are GMT +1. The time now is 11:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us