Well, I wouldn't say brilliant, but it sure is a lot easier.
On Wednesday, 10 August 2016 09:42:29 UTC+1, wrote:
try the following:
- put 100 in an empty cell and copy this cell
- select your other values
- goto 'Edit - Paste Special' and choose 'Multiply' to multiply them
all in one single step
THANK YOU All