Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

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")
share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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