Format column - problem

  • Thread starter Thread starter h2o
  • Start date Start date
H

h2o

Hello for everyone,
I would be gratefull for help in my problem.
I have column with 645 boxes, in every box is insert value - ex:1,34; 1,59;
10,50
Is it possible to change automatically values at very box at this column for
+100%

Please for help
Chris
 
Hi
try the following:
- enter '2' in an empty cell
- copy this cell
- select your values
- goto 'Edit - Paste Special' and choose 'Multiply'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Need help formatting rows 2
Excel Reference to text returning "0" value on second column 0
conditional formatting 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Create a Macro to give movement to a graphic. 4
Coverting data from some columns to rows (but not the primary colu 5
Sum up cells in column A that has same text in Column B. 4

Back
Top