View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
How to convert from 100- to -100 How to convert from 100- to -100 is offline
external usenet poster
 
Posts: 1
Default How do you convert 100- to -100?

I have a spread sheet that instead of having -100 (negative 100), it shows
negaive 100 as 100-, is there anyway that I can convert this back to -100
faster by using a formular instead of typing it one by one, it's like 1000+
rows. Thanks.