Results 1 to 4 of 4

Changing a Series of Numbers in an Excel sheet column

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2009
    Location
    Planet Earth
    MS-Off Ver
    Microsoft Office 2010
    Posts
    22

    Changing a Series of Numbers in an Excel sheet column

    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?
    Last edited by KoolSIM; 04-30-2009 at 03:15 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1