|Subject:||Minus sign on the wrong side|
|Posted by:||Ralf (rjvandal…@chello.nl)|
|Date:||Sun, 16 May 2004|
When I copy and paste data from a financial program, the minus sign is
sometimes on the right sight of the amount,
and Excel considers the data as text. I now sort and replace the minus
sign, however, I think there must be a fomula
to move the minus sign to the left, and format the call as a value.