I would like to accomplish a couple of MS Access features in Excel:
1. Primary Key - automatic numbering of entries in rows without
replication allowance. Part of it is solved with data validation using
=COUNTIF function, right?
2. Date formatting - when you tab to the column for date entry, a guide
like "____-__-__" will popup and I just need to type in 20050721.
Please advice.


*** Sent via Developersdex http://www.developersdex.com ***