Scientific notation

[Guest]

I have a rather extensive excel spreadsheet and when I save it into CSV
format and try and import it into a SQL database I cannot due to the number
been in scietific notation. I have foramted the numbers inot number format.
What am I doing wrong?

 

[Jamie Collins]

I have a rather extensive excel spreadsheet and when I save it into CSV
format and try and import it into a SQL database I cannot due to the number
been in scietific notation. I have foramted the numbers inot number format.
What am I doing wrong?

Please post some sample data.

Jamie.

--

 

[Dave Peterson]

If you open that .csv file in Notepad, are those numbers really in scientific
notation?

If no, then it sounds like it's not excel's problem.

If yes, maybe you could create that .csv file with a little more control.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html