MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"MultiplyTimes1000" macro


Posted by Dwight on May 30, 2001 11:10 AM

Want a macro which I can run after selecting a range of cells which will multiply the entire range by 1000, leaving formatting intact.

Any ideas?


Posted by Mark W. on May 30, 2001 11:20 AM

Take a look at ASAP Utilities' Numbers |
Apply formula to selected cells command.

Free at www.asap-utilities.com

Posted by Tom on May 30, 2001 11:22 AM


Dim cell As Range
For Each cell In Selection
If IsNumeric(cell) And cell <> "" Then cell.Value = cell * 1000
Next

Note : If any of the cells in the selection contain formulas, the above will convert them to values only


Posted by Aladin Akyurek on May 30, 2001 11:33 AM

ASAP+

Hi Mark

Bastien, a Dutch guy as it turned up, informed that his utilities are not available for the Mac because he doesn't have access to a Mac.

Aladin