Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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...?

Thanks

Re: mass calculations/conversion

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.