Forum Sementara Putera.com

Would you like to react to this message? Create an account in a few clicks or log in to continue.
Forum Sementara Putera.com

Bersama kita perkemaskan forum ini sementara forum asal dalam pemulihan.

Forum putera dah kembali. Masalah sudah berjaya diselesaikan. Sila lawati http://forum.putera.com/tanya


2 posters

    defaulr value

    sharina
    sharina
    Ahli Baharu
    Ahli Baharu


    Gender : Female Number of posts : 151
    Age : 44
    Location : Seri Kembangan
    Job/hobbies : makan & tidow **tu pown klu rajin..
    Registration date : 06/08/2009

    defaulr value Empty defaulr value

    Post by sharina Thu Aug 06, 2009 4:02 pm

    sapew tau nak wat default value in excel,,,
    contohnye,,, dlam row A hya "SI" jer leh key in,,,xtau la!!!
    mikicun
    mikicun
    Ahli Baharu
    Ahli Baharu


    Gender : Male Number of posts : 199
    Location : somewhere i belongs...
    Registration date : 15/02/2009

    defaulr value Empty Re: defaulr value

    Post by mikicun Thu Aug 06, 2009 11:26 pm

    "SI" tu apa?
    huruf SI saja ka atau unit metrik?
    sharina
    sharina
    Ahli Baharu
    Ahli Baharu


    Gender : Female Number of posts : 151
    Age : 44
    Location : Seri Kembangan
    Job/hobbies : makan & tidow **tu pown klu rajin..
    Registration date : 06/08/2009

    defaulr value Empty Re: defaulr value

    Post by sharina Fri Aug 07, 2009 9:58 am

    mikicun wrote:"SI" tu apa?
    huruf SI saja ka atau unit metrik?

    "SI" sajer,,
    not unit SI,, or another example like "ID"
    avatar
    Guest
    Guest


    defaulr value Empty Re: defaulr value

    Post by Guest Fri Aug 07, 2009 10:14 am

    1- choose which cell that you don't want to be protected (default is locked)
    right click cell > format cells > protection tab > check or uncheck Locked

    2- protect the sheet except for the uncheck locked cell
    tools > protection > protect sheet

    done.
    sharina
    sharina
    Ahli Baharu
    Ahli Baharu


    Gender : Female Number of posts : 151
    Age : 44
    Location : Seri Kembangan
    Job/hobbies : makan & tidow **tu pown klu rajin..
    Registration date : 06/08/2009

    defaulr value Empty Re: defaulr value

    Post by sharina Fri Aug 07, 2009 10:29 am

    iluvkarim.selamat wrote:1- choose which cell that you don't want to be protected (default is locked)
    right click cell > format cells > protection tab > check or uncheck Locked

    2- protect the sheet except for the uncheck locked cell
    tools > protection > protect sheet

    done.

    i think this is not the solution,,,
    what i want to know is how to make a default value just for one cell???
    if the user key in that more than 3 character in that cell,, the output msg will appear,,,
    now,, i dun know how to make a default value only,,, huhu ,, help me plez
    avatar
    Guest
    Guest


    defaulr value Empty Re: defaulr value

    Post by Guest Fri Aug 07, 2009 11:28 am

    Owh that.
    So the correct question is cell validation.

    goto Data > Validation > Settings tab
    here you can try the text length validation

    Validation criteria:
    Allow:

    Text length

    Data:
    equal to

    Length:
    2

    You can create your own Input Message and Error Alert in their tab.


    Last edited by iluvkarim.selamat on Fri Aug 07, 2009 11:38 am; edited 1 time in total
    sharina
    sharina
    Ahli Baharu
    Ahli Baharu


    Gender : Female Number of posts : 151
    Age : 44
    Location : Seri Kembangan
    Job/hobbies : makan & tidow **tu pown klu rajin..
    Registration date : 06/08/2009

    defaulr value Empty Re: defaulr value

    Post by sharina Fri Aug 07, 2009 11:32 am

    iluvkarim.selamat wrote:Owh that.
    So the correct question is cell validation.

    goto Data > Validation > Settings tab
    here you can the text length validation

    Validation criteria:
    Allow:

    Text length

    Data:
    equal to

    Length:
    2

    You can create your own Input Message and Error Alert in their tab.




    thnx a lot,, can i set just "s" and "i" character only in that cell?
    avatar
    Guest
    Guest


    defaulr value Empty Re: defaulr value

    Post by Guest Fri Aug 07, 2009 11:44 am

    In that case, try this

    Validation criteria:
    Allow:

    List

    Data:
    between (excel fixed for you)

    Length:
    s, i

    The cell should become a drop-down list.
    If you want to add more option just do this:
    example: s, i, x, x, x
    sharina
    sharina
    Ahli Baharu
    Ahli Baharu


    Gender : Female Number of posts : 151
    Age : 44
    Location : Seri Kembangan
    Job/hobbies : makan & tidow **tu pown klu rajin..
    Registration date : 06/08/2009

    defaulr value Empty Re: defaulr value

    Post by sharina Fri Aug 07, 2009 12:14 pm

    iluvkarim.selamat wrote:In that case, try this

    Validation criteria:
    Allow:

    List

    Data:
    between (excel fixed for you)

    Length:
    s, i

    The cell should become a drop-down list.
    If you want to add more option just do this:
    example: s, i, x, x, x


    xbole jgk,,
    cuz if i choost List,
    the data "between" xbole
    avatar
    Guest
    Guest


    defaulr value Empty Re: defaulr value

    Post by Guest Fri Aug 07, 2009 12:34 pm

    Sorry I don't get it.

    If you use List, the Data: will be fixed to between. So you can't choose other option.
    in Length:, you can either have a multiple value such as: s, i, g, h
    or you can just put 1 value such as: s

    By using List, user can only choose between those pre-fixed value you entered.
    example: s, i
    So user can only choose either s or i, or there will be a popup error.
    Takpala kalau tak paham gak, japgi saya terang dalam Malay
    sharina
    sharina
    Ahli Baharu
    Ahli Baharu


    Gender : Female Number of posts : 151
    Age : 44
    Location : Seri Kembangan
    Job/hobbies : makan & tidow **tu pown klu rajin..
    Registration date : 06/08/2009

    defaulr value Empty Re: defaulr value

    Post by sharina Fri Aug 07, 2009 12:45 pm

    iluvkarim.selamat wrote:Sorry I don't get it.

    If you use List, the Data: will be fixed to between. So you can't choose other option.
    in Length:, you can either have a multiple value such as: s, i, g, h
    or you can just put 1 value such as: s

    By using List, user can only choose between those pre-fixed value you entered.
    example: s, i
    So user can only choose either s or i, or there will be a popup error.
    Takpala kalau tak paham gak, japgi saya terang dalam Malay

    huhu,,
    thnks a lot,,
    da siap da,,

    Sponsored content


    defaulr value Empty Re: defaulr value

    Post by Sponsored content


      Current date/time is Thu Mar 28, 2024 5:43 pm