problem with open text file in excel 2007
Hi
I have a textfile from a databasa that I every week opens in excel. I
haven't had any problems with this until we changed to office 2007.
In the textfile there is numbers like 1.072,00- and when I open it in Excel
2003 I get it like -1 072,00 which is exactley what I want. When I do the
same settings in 2007 it seems to ignore them and also sets it as text format
so it looks like 1.072,00-
I have tested it in swedish and english version and I get the same result.
My settings:
Delimiter : tab
Format: general
decimalseparotor (under advanced) : ,
1000-delimiter: .
and I check the little checkbox
Thees settings works perfectley for me in 2003 but not in 2007, is it me or
is it a bug?
|