View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lina Lina is offline
external usenet poster
 
Posts: 20
Default 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?