locked
Number Field Validation. RRS feed

  • Question

  • Hello,

    I have number field as column in a Sharepoint List. I wnated to validate it in such a way that user can enter value starting with 3 Zeroes... i.e.... 000.... Please help me on this... Validation can be applied only through List Settings.

    Friday, April 24, 2015 6:26 AM

Answers

  • I'm sorry but a number cannot start with leading 0...

    You have to create a text field with a validation formula like this...


    Regards,
    Bubu
    http://zsvipullo.blogspot.it

    Please mark my answer if it helped you, I would greatly appreciate it.

    Friday, April 24, 2015 8:21 AM

All replies

  • I'm sorry but a number cannot start with leading 0...

    You have to create a text field with a validation formula like this...


    Regards,
    Bubu
    http://zsvipullo.blogspot.it

    Please mark my answer if it helped you, I would greatly appreciate it.

    Friday, April 24, 2015 8:21 AM
  • Ok... Thanks... Can i make an condition like it should start with number 100
    Friday, April 24, 2015 8:27 AM
  • Hi

    i agree with Sergio, if you need "000"

    But if you need that your column should have a standard number of digits, attach a workflow to your list, when an item is added , to replace your column's value with specific number of zeros based on column's length


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Friday, April 24, 2015 8:28 AM