MrExcel Publishing
Your One Stop for Excel Tips & Solutions

mass calculations/conversion

Posted by Rolf Herbert on November 08, 2000 7:12 AM

hi there,
is there a way of doing a mass conversion on a selected bunch of cells, eg multily then all by 1000 or whatever...I dont need formulas its just from some one off conversions....any ideas...?


Posted by Loren on November 08, 2000 12:30 PM

enter your multiplier in empty cell.
Edit-copy it. Highlight target cells.
Edit-Paste special-Multiply. All the target cells
will be changed.