Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My column cell values are -ve how do I make all cell value +ve,
Entire column has -ve numbers, wants to chage it to +ve numbers, with just
one step. I have hundreds of colums to be changed I will appreciate any help I can get. . |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My column cell values are -ve how do I make all cell value +ve,
All your numbers are negative?
Step 1. Put -1 in an empty cell edit|copy select the range to fix edit|paste special|click multiply clean up that cell with the -1 in it (no step 2) Harshad Mehta wrote: Entire column has -ve numbers, wants to chage it to +ve numbers, with just one step. I have hundreds of colums to be changed I will appreciate any help I can get. . -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My column cell values are -ve how do I make all cell value +ve,
Put -1 in an empty cell somewhere, select that cell and click <copy.
Then highlight all the cells you want to change and Edit | Paste Special | Multiply (check) | Values (check) | OK then <Esc Hope this helps. Pete On Jul 13, 5:20 pm, Harshad Mehta <Harshad wrote: Entire column has -ve numbers, wants to chage it to +ve numbers, with just one step. I have hundreds of colums to be changed I will appreciate any help I can get. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My column cell values are -ve how do I make all cell value +ve,
Select your ranges Ctrl+H Find what: - Replace with: leave
blank Replace All "Harshad Mehta" wrote: Entire column has -ve numbers, wants to chage it to +ve numbers, with just one step. I have hundreds of colums to be changed I will appreciate any help I can get. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to make conditional sounds based on cell values in Excel | New Users to Excel | |||
How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
Make new column using partial text in another cell | Excel Worksheet Functions | |||
Make a formula that adds every 4th cell in a column indefinately? | Excel Worksheet Functions | |||
how to make bmp or jpgs graphics be treated as cell values | Excel Discussion (Misc queries) |