1

May I know if there is any settings that I can set such that my column (which is of type - number) will auto insert 0s in front of the number that a user enter?

Scenario
A SharePoint 2007 List have a field - a number field. The number field allows only 5 digits of numbers - meaning that if the number field contain a number, say 136, it will display 00136. If another number, say 66, then it will display 00066.

0

As far as I know this is not possible directly on your number column.

However you can add calculated column to your list and use formula:

=TEXT([YourNumberColumn],"00000")
  • Looks like calculated column is the most useful column in SharePoint, or am I wrong to say that? – Larry Morries Sep 21 '11 at 9:03
  • It is very useful – Vedran Rasol Sep 21 '11 at 9:22
  • how can I chat with you and the rest of the people in the sharepoint chatroom? I keep getting error saying my data is too old? (Can tell me which internet browser you are using - probably I can use the same browser to chat with you all) Thanks. – Larry Morries Sep 21 '11 at 9:35
  • I am using Chrome. If you have any problems (bugs) post them on meta.sharepoint.stackexchange.com – Vedran Rasol Sep 21 '11 at 9:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.