View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jln via OfficeKB.com jln via OfficeKB.com is offline
external usenet poster
 
Posts: 88
Default Problem with a a number ending in -

Ok a system that i work with outputs a neg number like this 100-. So the
problem is this, since the system does this it make that number text. What i
need is if - show up i need to some how move it to the first spot so that it
can be viewed as a number and not text.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200710/1