Subject: | |
From: | |
Reply To: | Dr. Ferenc Nagy |
Date: | Thu, 2 Apr 1998 13:49:06 +0200 |
Content-Type: | TEXT/PLAIN |
Parts/Attachments: |
|
|
On Wed, 1 Apr 1998, Mark Wonsil wrote:
> Be careful with Microsoft's DIF import. We were sending General Ledger
> account numbers in the form "2-10-55" and Excel converted them to dates even
> though we followed the DIF spec of a text cell. We got around it with some
> VBA code and the MS rep said a fix may make it into the next version.
>
Hi Mark,
You are right. I got dates from such data as above but not only from DIF,
but from plain text data. My similar adventuire was when I read a text
file made by DBFINDER. The DBFINDER wroter thosand separating commas,
when the chainlenghts were above 1,000. My Excel uses commas to separate
integer and fraction parts, and points to separate thousands (German =
Hungarian convention). So I had to get rid of the columns containing
commans before reading in the table in Excel.
Regards
Frank
|\ /~ ~~|~~~ Family : NAGY; first name : FERENC; title : Ph. D.
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- H-1121 BUDAPEST Konkoly-Thege M. ut 29, (1525 Bp. POB 77)
| \ | | [log in to unmask] (36-1)-395-9123 Fax: ~395-9002
| \| | http://alpha0.iki.kfki.hu/~nagyf/
`-' ' `-' Home: H-1102 BUDAPEST Holgy u. 48. I. 8. (36-1)-262-1198.
The lazy man gets tired twice, the miser pays doubly.
|
|
|