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
|