Page 1
Page 1
Started By
Message

Nothing to see here

Posted on 10/22/14 at 4:35 pm
Posted by thedogman
Member since Dec 2008
2250 posts
Posted on 10/22/14 at 4:35 pm
Move along
This post was edited on 10/22/14 at 4:56 pm
Posted by Winkface
Member since Jul 2010
34377 posts
Posted on 10/22/14 at 4:35 pm to
*100
Posted by baytiger
Boston
Member since Dec 2007
46978 posts
Posted on 10/22/14 at 4:35 pm to
just multiply the column by 100?
Posted by aaronb023
TeamBunt CEO
Member since Feb 2005
11774 posts
Posted on 10/22/14 at 4:36 pm to
Multiply them times 100 without formatting as %
Posted by thedogman
Member since Dec 2008
2250 posts
Posted on 10/22/14 at 4:37 pm to
multiply by 100 got that but how do you do it by the entire column
Posted by Winkface
Member since Jul 2010
34377 posts
Posted on 10/22/14 at 4:38 pm to
drag it
Posted by burdman
Louisiana
Member since Aug 2007
21101 posts
Posted on 10/22/14 at 4:38 pm to
Are you trying to turn 47.5% into 47.5, or are you trying to turn .475 into 47.5?

ETA: Nevermind.
This post was edited on 10/22/14 at 4:39 pm
Posted by Rabbs and QStick
Houston
Member since Apr 2012
2920 posts
Posted on 10/22/14 at 4:39 pm to
drag the formatting all the way down to copy the formula
Posted by Croacka
Denham Springs
Member since Dec 2008
61447 posts
Posted on 10/22/14 at 4:40 pm to
is this your first time using excel?



drag the little tiny black box at the bottom of the formatted cell down your entire column and it should copy the formula
Posted by TexasTiger01
Lake Houston
Member since Nov 2013
3215 posts
Posted on 10/22/14 at 4:41 pm to
Hire someone to do that petty shite...
Posted by thedogman
Member since Dec 2008
2250 posts
Posted on 10/22/14 at 4:43 pm to
quote:

is this your first time using excel?


not at all

I have the info in the cell as .0012345 I need it as .12345000. The info is already in the cells and I understand I need to multiply all cells by 100 but how would you do it all at once
Posted by sloopy
Member since Aug 2009
6893 posts
Posted on 10/22/14 at 4:44 pm to
Format first cell then drag that formatting down the column.
This post was edited on 10/22/14 at 4:45 pm
Posted by DoUrden
UnderDark
Member since Oct 2011
25965 posts
Posted on 10/22/14 at 4:45 pm to
put the number 100 in a cell off to the side
right click, copy
highlight cells you want to convert
right click, paste special, select multiply
This post was edited on 10/22/14 at 4:46 pm
Posted by Croacka
Denham Springs
Member since Dec 2008
61447 posts
Posted on 10/22/14 at 4:45 pm to
quote:

I have the info in the cell as .0012345 I need it as .12345000. The info is already in the cells and I understand I need to multiply all cells by 100 but how would you do it all at once


so do you need the new number in the same cell that its currently in? or can you go over a column for the new numbers?
Posted by lynxcat
Member since Jan 2008
24521 posts
Posted on 10/22/14 at 4:49 pm to
I clicked expecting something complicated but I got a good chuckle out of the simplicity of what he needs
Posted by undrafted
DHA
Member since Oct 2009
1004 posts
Posted on 10/22/14 at 4:53 pm to
Do you work for the government or are you a CEO????
Posted by Hammertime
Will trade dowsing rod for titties
Member since Jan 2012
43030 posts
Posted on 10/22/14 at 4:54 pm to
Why would you accept the task if you have basically zero idea how to use excel?
Posted by Croacka
Denham Springs
Member since Dec 2008
61447 posts
Posted on 10/22/14 at 4:56 pm to
just make the column narrower and narrower until you can no longer see the % sign
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram