View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How to remove a - sign after the number

Have you tried (Ctrl+ H) Find and replace with blank..

If this post helps click Yes
---------------
Jacob Skaria


"Meeru" wrote:

The number extraced from our financial software shows a minus sign after the
number. for e.g
123,768-
i cannot do any calculation on this numbers as it does not recognise it as a
number, any qick way to delete the - (minus) sign after the number.
thanks in advance:)
meeru