Default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

For xample if i have a Field Zip Codes and i want to make sure that you can
not add more than 8 numbers in it how do i do that. Also if less that 8
numbers are added, the starting digits should be 0 as default.

Any idead how can i do that. so for eg i entered 12345678 it should
accept...but if i enter 12345 it shoudl show up as 00012345

thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV - text 6
Passwords 2
Formatting Zip Codes 3
working with length formula 3
Default number format in Excel 1
Numbers as Text 1
sort numbers based on initial digit. 2
Can a field value be customized? 2

Back
Top