Thanks for taking time answering this. I just wonder how the number looked in
excel for you, did you get it like - 1 072,00 ?


"Jim Rech" wrote:

I switched my Windows Regional settings to a country that uses the . as the
thousands separator and the , as the decimal point. Then I created a text
file using numbers like your example ( 1.072,00- ). It came into Excel
okay. Sorry I don't know what is wrong.

--
Jim
"Lina" wrote in message
...
|I have that one selected and it does not work for me in 2007 but it does in
| excel 2003.
|
| On the screen with advanced settings in the guide my settings is:
| decimalseparotor: ,
| 1000-delimiter: .
| treating trailing minus signs as a negative number: is checked
|
|
| "Jim Rech" wrote:
|
| When I open a text file in your format (having a TXT extension, not CSV)
in
| Excel 2007 the Text Import Wizard appears. On the third of three
screens
| the Advanced button provides several options including treating trailing
| minus signs as a negative number. If that's selected it works okay for
me.
|
| --
| Jim
| "Lina" wrote in message
| ...
| | 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?
|
|
|