Re: csv converting numbers to scientific format

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dave,

Yes, the numbers showed in scientific notation when I opened it with
notepad. I would just change it after opening the file, but the file is being
uploaded into another DB, and it needs to be automated. Any idea why it
won't hold the format change when saving it as a csv file?

--
JR Wireless


"Dave Peterson" wrote:

> When you opened the .CSV file in Notepad (say), were those numbers in scientific
> notation?
>
> Or was it when you reopened the .csv file in excel.
>
> And if it's just the format in excel, you could always just change the format of
> that column(s) after you open the file.
>
> JR wrote:
> >
> > I've imported a series of numbers and when I save it in csv format, it
> > changes the numbers to the scientific format unless it's under 10 digits.
> > I've tried converting to text, multipling by 1, but nothing seems to keep it
> > formatted as a number? Each time it looks like it will work, I save it and
> > reopen it, only to find the numbers converted to scientific format again.
> >
> > I'm completely confused as to why it won't store it as a general number if
> > over ten digits?
> > --
> > JR Wireless
>
> --
>
> Dave Peterson
>
.

Relevant Pages

  • Re: Need performance help
    ... Monitor utility output to Comma Separated Value format files. ... At least one CSV file must be specified. ... the matching parameters from all the files are shown on the same chart. ... specify the commands on the command line. ...
    (comp.os.vms)
  • Re: Passing FieldInfo Array from VBS to objExcel.OpenText
    ... The .csv file is comma delimited, text is enclosed in double quotes, dates ... are in format dd-mm-yyyy. ... I am Dutch and Excel on our server is configured to semicolon as field ... xlGeneralFormat), Array(4, xlTextFormat), Array, Array(6, ...
    (microsoft.public.scripting.vbscript)
  • Re: date format changes when I save to CSV via a macro
    ... So it looked like the formatted text was saved in the .CSV file. ... But the problem occurs when I try to bring that data back into excel. ... a date according to my windows short date format. ... When the data is pasted across into the macro workbook, ...
    (microsoft.public.excel.misc)
  • Re: Problem with CSV Date column
    ... to format, so you can specific to include any format you want. ... Dim csvConnection As OdbcConnection ... ' Create connection to folder containing CSV file ... OleDbConnection ...
    (microsoft.public.dotnet.languages.vb)
  • Re: save as csv cell format
    ... they are set for dd/mm/yyyy. ... I opened the file in Notepad, ... Open that CSV file in NotePad to check it out. ... I 'saveas' the file in *CSV format and when I open the CSV file the date ...
    (microsoft.public.excel.programming)