Hi!
That is painful problem for me too, even when I try to open Excel files
with values similar somehow to dates. If the file is small I do it in
terrible (but the only I know) way. I copy (or open) it before to writer
and then from writer to calc. Then calc recognize content of cells as
text. I would like to have better solution.
May be you can try to change number format in default style to text and
then paste information from text file to calc and then change number
styles to what you need in certain columns.
Andis
Bengt Sebring wrote:
Vår/Our ref: BS E70659 27 May 2007
When I try to import a txt-file into Open Office Calc some columns set
themselves to date-format and it seem impossible to get back to the
original numbers. The numbers are like 30.1 becomes 30-01-01. It seem
to be the single decimal numbers that turn into date, not the double
decimal numbers like 30.54.
I am using a dos-format for the import, Nordic Dos.
The problem makes it impossible to use Open Office Calc. I have to use
MS Exel.
Vänliga hälsningar/Best regards
*Bengt Sebring
*Försäljningschef/Sales Manager
*CHS Controls AB
*Florettgatan 33
SE-254 67 Helsingborg, Sweden
Tel dir +46 42 386102, Swb +46 42 386100
Fax +46 42 386129, Mobile +46 705 151282
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
www.chscontrols.se <http://www.chscontrols.se/>
------------------------------------------------------------------------
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Bengt Sebring
TEL;FAX:+46 42 386129
TEL;WORK:+46 42 386102
TEL;PREF;FAX:+46 42 386129
EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED]
N:Sebring;Bengt
TITLE:Sales Manager
ADR;INTL;WORK;PARCEL;POSTAL:;;Florettgatan 33;HELSINGBORG;;SE-254 67;Sweden
LABEL;INTL;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Bengt Sebring=0A=
Florettgatan 33=0A=
HELSINGBORG SE-254 67=0A=
Sweden
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Bengt Sebring=0A=
Florettgatan 33=0A=
HELSINGBORG SE-254 67
TEL;CELL:+46 705 151282
TEL;PREF:+46 42 386102
URL;WORK:http://www.chscontrols.se
ORG:CHS Controls AB
END:VCARD
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
