Minus sign on the wrong side

Giganews Newsgroups
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.