VBA Multiplication

[pouliotg]

I have data in Columns("F:L") and I would like for each cells that contains numerical data to be multiply by 1000? What code could I write to make this calculation?

Thanks

 

[just_jon]

Would you rather not use code?

Enter 1000 in an unused cell and - while that cell is selected - click Copy.

Now highlight the range to multiply and click Edit | PasteSpecial | choose Multiply

You're done, and can now delete that 1000 in the cell.