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

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

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


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.