Jump to content
Sign in to follow this  
wykikitoon

Excel Guru's

Recommended Posts

If they're all in one column, can you just set it up so that the cell next to them has the formula:

 

=A1(or whatever the cell you're trying to divide is)/1000

 

Then you just copy that down for all of the cells beneath.

Share this post


Link to post
Share on other sites

Type 1000 into a different cell. Click on it and do ctrl-c.

 

Highlight all the cells you want to divide by 1000, and select paste special. Then click the Divide button in the paste special menu and hit ok.

 

Done.

Share this post


Link to post
Share on other sites

Type 1000 into a different cell. Click on it and do ctrl-c.

 

Highlight all the cells you want to divide by 1000, and select paste special. Then click the Divide button in the paste special menu and hit ok.

 

Done.

 

Boom

 

Legend, cheers :D

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

Recent tweets

Toontastic Facebook

Donate to Toontastic

Keeping the lights on since... well ages ago
TT-Staff


×