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%