View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Meeru Meeru is offline
external usenet poster
 
Posts: 16
Default How to remove a - sign after the number

Thanks Jacob, i have tried that, but it removes the - but i would like to
have it placed at the beginning of the number.

thanks
meeru

"Jacob Skaria" wrote:

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