Hi

Copy one minus-sign
Select the range with values. Check, that range is formatted as numeric or
general.
Replace all minus-signs with "-". It's done! (you had there 'long -', which
you get when you enter double '-' p.e. in MS Word.)


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"drs" wrote in message
...
I have negative numbers in my worksheet that are text such as –6.90%. I try
converting them to number using the paste special multiple or add and they
stay as text. When I sort the columns in descending order they continue to
come out as text and right justified. could it be the the negative sign is
not a real negative sign.
–6.90%
–5.61%
–5.37%
–35.80%