Changing a Series of Numbers in an Excel sheet column

**KoolSIM** · 04-29-2009, 08:43 PM

Hi

I have a series of numbers in one column. Is there some way I can divide all the numbers together by, say 10, without doing it manually?

eg.

12
15
15
25
20

should become

1.2
1.5
1.5
2.5
2.0

Is there a way in Excel to do that?

**shg** · 04-29-2009, 09:01 PM

Put 10 in a cell and do Edit > Copy.

Select the other cells, do Edit > Paste special, tick Divide and Values

**zbor** · 04-30-2009, 02:13 AM

Or in one cell (eg B1) put number (wich you can change as you need) eg 10.

Then in C1 write =A1/$B$1 and extend down while you have data

**KoolSIM** · 04-30-2009, 03:10 AM

thanks a lot people!!! finally I know one more thing out of a billion things in Excel!

Changing a Series of Numbers in an Excel sheet column

LinkBack

Thread Tools

Rate This Thread

Display

Changing a Series of Numbers in an Excel sheet column

Re: Changing a Series of Numbers in an Excel sheet column

Re: Changing a Series of Numbers in an Excel sheet column

Re: Changing a Series of Numbers in an Excel sheet column

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions