convert text to numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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%
 
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.)
 
I think I'm doing this wrong. I selected my range of cells and made all cells
'percentage'.
I tried a replace "--" to"-" and it didn't find anything.
 
No!

You must copy 'double-minus' from one of cells.
– (that is what you have there, it's ASCII code = 150) doesn't equal --
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ascending Sort formula, change to neg #: descending sort.. 6
Converting text to numbers 3
how to convert text with trailing minus sign to number 4
Excel 2002 : Convert Positive Numbers to Negative Numbers ? 2
convert cells to negative number 3
Converting text to numbers 3
change negative sign from end of the number to the begining 11
Data Validation - allowing only negative numbers or converting 13

Back
Top