| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell values
How do you convert negative cell number entries to positive?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell values
In an un-used cell enter -1 and then copy this cell. Then select the cells
you want to change and Paste/Special/Multiply -- Gary''s Student - gsnu200771 "Derek Dainton" wrote: How do you convert negative cell number entries to positive? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell values
"Derek Dainton" wrote:
How do you convert negative cell number entries to positive? One way, assuming numbers (positives, negatives, with maybe some blank cells) are in A2 down, you could place in B2, copied down: =IF(A2="","",ABS(A2)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell values
The earlier suggestion assumes that the conversion is to be applied only for
the negatives in the entire col, viz you would want to leave positives as positives & the blanks as "blanks" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to assign values to a cell based on values in another cell? | Excel Worksheet Functions | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Discussion (Misc queries) | |||
| Insert a value in a cell based upon a comparison of cell values in 2 separate worksheets | Excel Worksheet Functions | |||
| Replacing Linked Cell Values w/ Current Values | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
Linear Mode
