+ Reply to Thread
Results 1 to 8 of 8

Changing number values into sequential text values.

  1. #1
    Registered User
    Join Date
    01-17-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Changing number values into sequential text values.

    Hi everyone,
    First time to this forum, was wondering how I can change a sequence of numbers from 1 - 100 in column A to read "(1%)" - "(100%)" in sequential order in column B without typing it out 100 times in text format. Excel does not recognize the text "(1%)" and so you can't just grab the box and drag it down 100 spaces.

    Does anyone know a formula so that when you type the number 1 into a box, it will show the character (1%) brackets included?

    Thanks,

    Al

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Changing number values into sequential text values.

    you could try this:
    in A1:
    =Row()/100
    drag down to row 100
    copy,paste special->values
    Format Cells as percentage

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,239

    Re: Changing number values into sequential text values.

    actually excel does recognize 1%. if you enter 1% in the 1st cell, then 2% in the 2nd, you can then just highlight the 2 cells and drag them down ad far as you want
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Changing number values into sequential text values.

    missed the brackets...darn
    in A1:
    =Row()/100
    drag down to row 100
    copy,paste special->values
    custom format ->(0%)

  5. #5
    Registered User
    Join Date
    01-17-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Changing number values into sequential text values.

    Hi, that does help a bit.

    One problem I have though is that I need the brackets to stay as part of the value. So that when the number 1 is entered, it automatically changes it to the character (1%) with the brackets.

    When you change the value to a percentage the brackets are removed.

    Is there a way to keep the brackets?

    Cheers

  6. #6
    Registered User
    Join Date
    01-17-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Changing number values into sequential text values.

    Thankyou! All good now.

    Thanks so much for your help!

  7. #7
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Changing number values into sequential text values.

    You are welcome

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Changing number values into sequential text values.

    For Text Output

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Or
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag it down...

    Real Number For Calculation Purpose
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag it down...

    Format the cells using Custom Format
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

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