Re: csv converting numbers to scientific format

Does saving the file to csv really convert it to scientific notation
(i.e., if you open the resulting file in NotePad, do you see scientific
notation?), or are you seeing scientific notation when you import it
back into XL (where the parser will convert it)?


In article <F30DA9F2-1657-4EA8-AC51-05F0046B56B1@xxxxxxxxxxxxx>,
"JR" <JR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> I saved the file as .xls, with the column formated as number. In .xls file
> type, it isn't a problem, but when I then save the file as a .csv, it again
> converts it to scientific. I've got a headache now from pounding my head
> against the wall...
.

Relevant Pages

  • Re: csv converting numbers to scientific format
    ... In my simple tests, when I put those large numbers in a cell, then formatted it ... as Number, then saved as a .csv file, the data didn't get converted ... What is the number format for that cell? ... > It really converts it to scientific notation, when I open it with notepad, I ...
    (microsoft.public.excel.misc)
  • Re: csv converting numbers to scientific format
    ... It really converts it to scientific notation, when I open it with notepad, I ... If I change it to .xls format, ... its only when I convert it to .csv that it forces it into ...
    (microsoft.public.excel.misc)
  • RE: how can I convert a XLS file into a CSV file
    ... you converted with the trial program in Notepad, to see if there's an obvious ... > I have a program that uses CSV files. ... > i open it in excell and save it as a xls file, but xls files are not accepted ... Until now I have used a free trial program to convert ...
    (microsoft.public.excel.misc)