wykikitoon 20713 Posted February 13, 2015 Share Posted February 13, 2015 Right I have a bunch of numbers in cells which I have extracted from a programme. I want these numbers dividing by 1000 and dont know how to do them en mass. Anyone help? Link to comment Share on other sites More sharing options...
Rayvin 5295 Posted February 13, 2015 Share Posted February 13, 2015 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. Link to comment Share on other sites More sharing options...
Gemmill 46023 Posted February 13, 2015 Share Posted February 13, 2015 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. Link to comment Share on other sites More sharing options...
wykikitoon 20713 Posted February 13, 2015 Author Share Posted February 13, 2015 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now