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?

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?

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?

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?
|
|
|

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?
|
|
|

I picked German settings so the numbers appeared like this: -1.072,00

Do numbers without trailing minus signs come in okay or does Excel treat
them as text too.? You can tell by looking at their alignment. If the
numbers are left aligned in the cell they are text. In that case I think
the problem is not the minus signs but the thousands separator, etc. Excel
2007 would seem to be acting as it would if you had US settings.


--
Jim
"Lina" wrote in message
...
| 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?
| |
| |
| |
|
|
|