I would change the extension to TXT and work through the Excel import wizard
to designate that column as text.

>
> I've got Sami's email on how to output an excel file with a headings row,
> but my first column is a budget number, 04123, which Excel imports and
> makes a general number of:  4123.
>
> The leading zero is significant. Any way to make Excel import it as text?
>
> In the CSV file, that field has the quotes:
> "04123","nextfield","more",etc.


================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/

Reply via email to