That removes the trailing minus changing the sign of the original value.
It's my understanding that they still want to retain the values as
negatives.

--
Biff
Microsoft Excel MVP


"MartinW" wrote in message
...
Hi,

I use 2000 premium also.
Try it this way.

DataText to Columns
Check Delimited
Click Next
Check Other and type in -
Click Finish

You can also do this with EditReplace
Find what: -
Replace with: Leave this blank
Click Replace all.

HTH
Martin


"via135" wrote in message
...
On Nov 24, 11:24 pm, "T. Valko" wrote:
Try this.

Select the range of cells in question
Goto the menu DataText to Columns
Click Next twice
Click Advanced
Make sure Trailing minus for negative numbers is checked
OK
Finish

--
Biff
Microsoft Excel MVP

"via135" wrote in message

...



hi

while importing a txt file into xl there is one column which is in txt
format having figures with trailing minus (ex: 100-, 150-,100000-).
how can i change them into real numbers for arithmetical
operations??? added to the head ache is that the column is aligned
horizontally centred!!!

any hlp pl?!

-via135- Hide quoted text -

- Show quoted text -

///Make sure Trailing minus for negative numbers is checked ///

hi Biff

there is no option in the advanced text import settings for trailing
minus.!

the options available are "Decimal seperator" & "Thousand seperator"
i'm using ms office 2000 premium.!

-via135