Move the negaive symbol from the right to the left side of a numbe
 

I have a situation whereby I am cutting and pasting a large volume of
negative values into Excel from another operating system and the the negative
values are on the right side of the number which Excel 2003 does not
recognise as a number.
Is there a setting in Excel that will recognise the negative if the
character is on the right.
Or, is there a macro/vba to move the negative from the right eg. 500.00-
to the left eg. -500.00.

Move the negaive symbol from the right to the left side of a numbe
 

Select all the numbers with trailing minuses, do datatext to columns, click
next twice, in step 3 select
and make sure that trailing minus for negative numbers is checked, then
click OK and finish
From now on (after making sure that box is checked) you can just select the
column(s) and do datatext to columns
and click finish


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Oldersox" wrote in message
...
I have a situation whereby I am cutting and pasting a large volume of
negative values into Excel from another operating system and the the
negative
values are on the right side of the number which Excel 2003 does not
recognise as a number.
Is there a setting in Excel that will recognise the negative if the
character is on the right.
Or, is there a macro/vba to move the negative from the right eg. 500.00-
to the left eg. -500.00.

Move the negaive symbol from the right to the left side of a numbe
 

Try using DataText to Columns.

Range of interest is A1:A5

A1 = 10-
A2 = 22.26
A3 = 15.99-
A4 = 5
A5 = 17.02-

Select the range A1:A5
Goto the menu DataText to Columns
Click Finish

This will place the minus sign on the left and it will be evaluated as a
negative number

Biff

"Oldersox" wrote in message
...
I have a situation whereby I am cutting and pasting a large volume of
negative values into Excel from another operating system and the the
negative
values are on the right side of the number which Excel 2003 does not
recognise as a number.
Is there a setting in Excel that will recognise the negative if the
character is on the right.
Or, is there a macro/vba to move the negative from the right eg. 500.00-
to the left eg. -500.00.