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.
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.
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?
Bruce
The older I get, the better I used to be.
USA
Yep! Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks