- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Nothing to see here
Posted on 10/22/14 at 4:43 pm to Croacka
Posted on 10/22/14 at 4:43 pm to Croacka
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 on 10/22/14 at 4:44 pm to thedogman
Format first cell then drag that formatting down the column.
This post was edited on 10/22/14 at 4:45 pm
Posted on 10/22/14 at 4:45 pm to thedogman
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
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 on 10/22/14 at 4:45 pm to thedogman
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?
Popular
Back to top
Follow TigerDroppings for LSU Football News