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
|