divide values by 10000

D

danielpaval

Hi! I have several hundreds of cells that contain big numbers. Now I
want to divide all of them, in one step!, by 10000... Couldn't find a
way to do this.. Any idea? Thanks.
 
S

swatsp0p

In a blank cell somewhere on your sheet, enter 10000. Copy this cell
(CTRL+C). Highlight the range you want to divide by 10000. Select
Edit>Paste Special and choose "Divide" in the Operation section and
click OK.

Done!

Does this work for you?
 

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 multiple list of values for variable 1
Getting the formula right 5
Combining three files when middle file has sections with endnotes 2
Auto populate value from one task to another in MS PROJECT 0
Segregate Outstanding Payment 1
Microsoft Office Standard 2013 0
sum based on value in a range 0
Custom Format numbers for learning chart 0

Top