How to make one standard "extension" in a column?

Discussion in 'Excel' started by sickpuppy, Sep 22, 2016.

  1. sickpuppy

    sickpuppy

    Joined:
    Sep 22, 2016
    Messages:
    3
    Likes Received:
    1
    My first entry here, and you have to excuse my bad english. I'm Norwegian and not the best in foreign languages(not using google translate tho').

    I got this excel-spreadsheet where I in one column is just keeping track of how many pieces I got to order from each part that appears on each line. I dont want the "extension" to appear in every line in the spreadsheet, coz' some of the lines does not have that kind of info. So I just want it to appear on those lines where I do input anything in the column on the left of the "extension-column".

    I dont know if you understand my problem, if not I can take a screenshot of an example and draw some explanations.. :)
     
    sickpuppy, Sep 22, 2016
    #1
    1. Advertisements

  2. sickpuppy

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    42
    Likes Received:
    4
    Welcome to the forum! :)

    I'm not sure I understand the issue here - could you take some screenshots of the problem?
     
    Becky, Sep 23, 2016
    #2
    1. Advertisements

  3. sickpuppy

    sickpuppy

    Joined:
    Sep 22, 2016
    Messages:
    3
    Likes Received:
    1
    I tried to explain it in this.. Does it help?
    [​IMG]
     
    sickpuppy, Sep 23, 2016
    #3
  4. sickpuppy

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    42
    Likes Received:
    4
    Ah ok, I understand now. Apologies for the late reply!

    Select the column, right-click on it and select 'Format Cells'. On the 'Number' tab you will see a list of categories on the left-hand side - select Custom. There is a box that you can type your own custom formatting into - you want to type

    #"stk"

    This mean that after a number, stk will appear automatically.

    Here's a screenshot:

    excel format example.png

    Hope this helps! :)
     
    Becky, Sep 26, 2016
    #4
    sickpuppy likes this.
  5. sickpuppy

    sickpuppy

    Joined:
    Sep 22, 2016
    Messages:
    3
    Likes Received:
    1
    Thank you very much, that made it exactly how I wanted it!
     
    sickpuppy, Sep 26, 2016
    #5
    Becky likes this.
  6. sickpuppy

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    42
    Likes Received:
    4
    You're welcome :)
     
    Becky, Sep 27, 2016
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.