Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need me first row to stay on left side as I move across thepage | Excel Discussion (Misc queries) | |||
How do I Move column A, B, etc. to left side. | New Users to Excel | |||
move y-axis labels on column chart from left to right side | Charts and Charting in Excel | |||
y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
In Excel can I move the tabs to the left side of the workbook? | Excel Worksheet Functions |