Home |
Search |
Today's Posts |
#1
|
|||
|
|||
changing a range of fields
I have a range of fields that needs to be changed from a posivtive number to
a negetive number, how do I changed a range of fields at a time? |
#2
|
|||
|
|||
Mr G
You can use another cell, so if you have 100 in A1 and in A2 enter =-A1 It will show -100. You can then copy this down as far as the data goes and then copy it and EditPaste special...Values over the existing data to replace it -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Mr. G." <Mr. wrote in message ... I have a range of fields that needs to be changed from a posivtive number to a negetive number, how do I changed a range of fields at a time? |
#3
|
|||
|
|||
Put -1 in a cell. Copy the cell, select all your data to be changed and do
Edit / Paste Special / Values & Multiply. Delete the -1. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Mr. G." <Mr. wrote in message ... I have a range of fields that needs to be changed from a posivtive number to a negetive number, how do I changed a range of fields at a time? |
#4
|
|||
|
|||
Thank you very much
"Nick Hodge" wrote: Mr G You can use another cell, so if you have 100 in A1 and in A2 enter =-A1 It will show -100. You can then copy this down as far as the data goes and then copy it and EditPaste special...Values over the existing data to replace it -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Mr. G." <Mr. wrote in message ... I have a range of fields that needs to be changed from a posivtive number to a negetive number, how do I changed a range of fields at a time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
changing the value of each cell in a range by a certain percentage | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
using sumproduct in a range of text fields? | Excel Worksheet Functions | |||
Counting a range of fields with an "X" | Excel Worksheet Functions |