| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If sign of sum is negative change to positive | Excel Worksheet Functions | |||
| Change of negative amount | Excel Discussion (Misc queries) | |||
| Formula with negative amount | Excel Discussion (Misc queries) | |||
| Ending Negative Sign | Excel Worksheet Functions | |||
| flip negative sign | Excel Discussion (Misc queries) | |||
Threaded Mode
