Thread: Deleting a negative sign from an amount in a list (not trailing negative)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam[_4_] Edwin Tam[_4_] is offline
external usenet poster
  
Posts: 23
Default Deleting a negative sign from an amount in a list (not trailing negative)
You just need to use the Find-Replace feature of Excel

- Select the cells you want to process
- From the Edit menu, choose Replac
- In the Find What box, enter - (negative sign
- For the Replace with box, leave it blan
- Click Replace Al


----- Fleming wrote: ----

I have a list of amounts and in the list are some amounts with
negative sign - I want to delete the negative signs but not th
amounts


--
Message posted from http://www.ExcelForum.com


Reply With QuoteReply With Quote