View Single Post
  #1   Report Post  
Scott
 
Posts: n/a
Default Converting text to numbers

I have a data file I'm reformatting that has all the negative numbers with
the negative sign on the right side thereby Excel sees these as text. I used
a formula last week that converts these to the correct negative number but
seemed to have misplaced the formula.

Anyone help me with this trick?