use of the minus sign
Posted by Eric Grant on January 28, 2002 1:49 PM
How can I get the minus sign in the correct position from imported data. It has come over as a trailing instead of leading minus??????
Posted by Aladin Akyurek on January 28, 2002 1:54 PM
See the formula at:
Posted by Juan Pablo G. on January 28, 2002 1:55 PM
You'll have to use a formula, like this one (If imported to Column A)
=IF(RIGHT(A1)="-",LEFT(A1,LEN(A1)-1)*-1,A1)
Juan Pablo G.
Posted by Mark W. on January 28, 2002 1:57 PM
A variation on a theme...
=IF(RIGHT(A1)="-",-LEFT(A1,LEN(A1)-1),A1)
