Importing to Excel

Article View: comp.apps.spreadsheets

Article #1

Back to comp.apps.spreadsheets Previous Next

From: Anders Ekeland
Date: Tue, 27 Oct 1992 18:08

15 lines
1175 bytes

I have encountered two problems with importing comma-separated ASCII-files into
Excel:

- My files comes from Paradox
1) When check the radiobutton "comma" Excel do  not separate the fields, but if
   I go down to "custum" and types in a comma, then it separates the
 field. No big problem but strange.

2) The next porblem is worse. It reformat fields like 04.05 as "4th - May" - 
and even worse - it does not help to reformat the cell to "number", because
Excel has added 1992!!!

Is there a way to force Excel not to do this silly conversion to dates
of numbers? Is the problem connected to how you set up Windows and
 Excel when it comes to decimal-delimiter, dateformat etc.? But iven if that is the case is not Excel trying to be too smart here?

Technical Details

Message-ID: <EKELAND.92Oct27190845@boeygen.nr.no>

Path: arc1-ca.pugleaf.net!sparky!uunet!mcsun!sunic!aun.uninett.no!nuug!nntp.uio.no!ekeland

Show Full Headers

Complete Article Headers

Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!mcsun!sunic!aun.uninett.no!nuug!nntp.uio.no!ekeland
From: ekeland@boeygen.nr.no (Anders Ekeland)
Subject: Importing to Excel
Message-ID: <EKELAND.92Oct27190845@boeygen.nr.no>
Sender: news@ulrik.uio.no (Mr News)
Nntp-Posting-Host: boeygen.nr.no
Organization: /nr/boeygen/u2/ekeland/.organization
Date: Tue, 27 Oct 1992 18:08:45 GMT
Lines: 15