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

Your Simple Answer solved my problem which took ages for me to fix.
Thanks a ton.

"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