Simply put the number that you want to multiply all the column(s) by in a spare cell off to the side.
Select the cell and Edit - Copy (or right click - copy) the cell
Then highlight all the numbers you want multiplied by the copied cell.
Then edit-paste special - select values - select multiply - OK
You can delete the number that you used to multiply by, the cell is no longer needed.