thanks Valko, i want the first option remove and replace, but i can do for
this for selecting only one column at a time. Since i have many numbers in 12
columns ( Jan to Dec ), how can i select the 12 column and do it at one go as
you suggested in option 1.
thanks
meeru

"T. Valko" wrote:

Do you want to remove it or relocate it to the front of the number making it
a negative number?

If you want to relocate it...

Select the cell(s) in question
Goto DataText to Columns
Click Next twice
Click Advanced
Make sure Trailing minus for negative numbers is checked
OKFinish

To remove it completely (assuming it's the only dash in the cell):

Select the cell(s) in question
Goto EditReplace
Find what: -
Replace with: nothing, leave this blank
Replace All

--
Biff
Microsoft Excel MVP


"Meeru" wrote in message
...
The number extraced from our financial software shows a minus sign after
the
number. for e.g
123,768-
i cannot do any calculation on this numbers as it does not recognise it as
a
number, any qick way to delete the - (minus) sign after the number.
thanks in advance:)
meeru