Thread: Deleting a negative sign from an amount in a list (not trailing negative)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Todd huttenstine Todd huttenstine is offline
external usenet poster
  
Posts: 260
Default Deleting a negative sign from an amount in a list (not trailing negative)
You can use the ABS() function. Adjust the reference in
the formula to where your values are located.

Example:
=ABS(A1)

If your range of values is in column A, then put this in
any cell and drag down.

Todd

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


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

.

Reply With QuoteReply With Quote