Hi Scott'
One way:
=LEFT(A1,LEN(A1)-1)*-1
---
Regards,
Norman
"Scott" wrote in message
...
I have a data file I'm reformatting that has all the negative numbers with
the negative sign on the right side thereby Excel sees these as text. I
used
a formula last week that converts these to the correct negative number but
seemed to have misplaced the formula.
Anyone help me with this trick?
|