Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - negative following the number
Hello all-
I have imported a column of numbers into an Excel 2003 spreadsheet from an in house program. When there is a number in the column that is negative, it displays the negative sign after the number (45.50- instead of -45.50). Is there a way to move the negative sign for the entire column to the front of the number? Thanks - Jason |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - negative following the number
One possibility would be =IF(RIGHT(A1,1)="-",-LEFT(A1,LEN(A1)-1),A1) .
-- David Biddulph "ohdharleyboy" wrote in message ... Hello all- I have imported a column of numbers into an Excel 2003 spreadsheet from an in house program. When there is a number in the column that is negative, it displays the negative sign after the number (45.50- instead of -45.50). Is there a way to move the negative sign for the entire column to the front of the number? Thanks - Jason |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - negative following the number
DataText to ColumnsNextNextAdvanced "Trailing minus for negative numbers"
Make sure you checkmark the option to "on" Then Finish Gord Dibben MS Excel MVP On Sun, 4 Feb 2007 09:49:00 -0800, ohdharleyboy wrote: Hello all- I have imported a column of numbers into an Excel 2003 spreadsheet from an in house program. When there is a number in the column that is negative, it displays the negative sign after the number (45.50- instead of -45.50). Is there a way to move the negative sign for the entire column to the front of the number? Thanks - Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
quattro pro converter Excel 2003 | New Users to Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |