+ Reply to Thread
Results 1 to 3 of 3

Fill Numbers

  1. #1
    Registered User
    Join Date
    06-02-2015
    Location
    US
    MS-Off Ver
    2013
    Posts
    2

    Fill Numbers

    Hey all,

    Im trying to get a fill in a column to go from 1.1 --> 1.01 -->1.001 and so on....how can I make this happen?

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Fill Numbers

    Hi,
    Welcome to the forum.

    Assuming A1 contains 1.1, then try this....

    In A2
    Please Login or Register  to view this content.
    and copy down.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    06-02-2015
    Location
    US
    MS-Off Ver
    2013
    Posts
    2

    Re: Fill Numbers

    Awesome it worked! Thank You. But just for my own knowledge (and future reference), can you break that down into what each value you listed means?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Fill even spaced numbers between two set numbers
    By dustinh48625 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-08-2013, 02:43 PM
  2. Fill Down help with 3 digit numbers
    By Photoray in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-07-2013, 05:45 AM
  3. Fill in consecutive ID numbers
    By bhogz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2012, 07:37 AM
  4. Fill Down sequence of numbers
    By aharvestofhealth in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-17-2010, 02:21 PM
  5. fill numbers from 2 cells in a row
    By d502 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2010, 07:01 PM

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