Ickle,
Thanks a lot for the suggestion - I looked into that possibility - however a number of data validation routines are setup to ensure the quality of data is accurate. Users entering the information get alerted if they are updating invalid information. If I were to gather to update the raw...
Hi,
I recently created a new master spreadsheet so that team members can update their information in it instead of maintaining their own forms. The new spreadsheet has a # of conditional formatting and data validation built in (special thanks to Chandoo for the validation rule for Social...
Hi my first post - hope this makes sense.
I need to setup a data validation routine so users can enter ss # in the the standard format (including #s starting with 0) ie
xxx-xx-xxxx
I had setup the spreadsheet using the custom format but the users started entering values without the...