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.

1 Answer 1

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")
4
  • Looks like calculated column is the most useful column in SharePoint, or am I wrong to say that? Commented Sep 21, 2011 at 9:03
  • It is very useful Commented Sep 21, 2011 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. Commented Sep 21, 2011 at 9:35
  • I am using Chrome. If you have any problems (bugs) post them on meta.sharepoint.stackexchange.com Commented Sep 21, 2011 at 9:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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