Posted to microsoft.public.excel.programming

Robert[_16_] Robert[_16_] is offline

external usenet poster

Posts: 29

Import Dropping Leading Zeroes

I am importing a comma delimited text file into an Excel
worksheet using Excel 97. Even though a field is
represented in the text file as "000234" (i.e. a text
field), it shows in the worksheet as 234.

How can I prevent the leading zeroes from being dropped?

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
Leading Zero dropping off after export to Excel	Tina Hudson	Excel Discussion (Misc queries)	3	March 30th 10 08:15 PM
Leading Zeroes	Melissa	Excel Discussion (Misc queries)	3	October 11th 06 07:38 PM
Converting xls to CSV file - dropping leading 0s	vanjohnson	Excel Discussion (Misc queries)	1	July 5th 06 07:47 PM
spreadsheet dropping leading zeroes when exporting from SQL Serve.	RPurgahn	Excel Worksheet Functions	0	June 29th 05 02:08 PM
CSV leading zeroes	Tim_nol	Excel Discussion (Misc queries)	2	December 28th 04 08:19 PM

All times are GMT +1. The time now is 12:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us