Hello,
I am trying to create a csv file from an excel worksheet. The proble
is when I open the file in excel, I get scientific notation. I als
have numbers that are supposed to be text. some of these numbers star
with zero, so most of the time it is lost when converting to csv with n
formatting.

How can I do this

--
fs
-----------------------------------------------------------------------
fsm's Profile: http://www.excelforum.com/member.php...fo&userid=1486
View this thread: http://www.excelforum.com/showthread.php?threadid=26494

fsm,

After saving the sheet as csv, open it with NotePad. NotePad won't change
formatting of the stuff as does Excel -- it just shows you the actual
characters in the file. For more about text files in Excel, see
www.smokeylake.com/excel/textfiles.htm.


--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"fsm" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hello,
> I am trying to create a csv file from an excel worksheet. The problem
> is when I open the file in excel, I get scientific notation. I also
> have numbers that are supposed to be text. some of these numbers start
> with zero, so most of the time it is lost when converting to csv with no
> formatting.
>
> How can I do this?
>
>
> --
> fsm
> ------------------------------------------------------------------------
> fsm's Profile:
http://www.excelforum.com/member.php...o&userid=14867
> View this thread: http://www.excelforum.com/showthread...hreadid=264948
>