Default format for text in a cell

S

Sdlentertd

I have three cells that people will be populating but i need to make
them with a default format and length.
so
Field 1 defalult will be character field 7 long 0123456
Field 2 defalult will be character field 9 long 012345678
Field 3 will be Numeric 06/01/2010 format

so if for the first field a person enters " 123456 (without the
leading 0) then an error message should pop up "enter 7 digits" ,
leaving the Field 1 blank until the 7 digits get entered..... same
with field 2
and Field 3 should have mm/dd/yyyy format
 

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

default format for text in cells 3
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Default date format 4
Time format hh:nn drops leading zero 0
Peculiar default cell format 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
Extracting Values from text embedded in cell 10
Storing a date in UK format 17

Top