Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Data Validation
Name: charlie1130s Date: June 2, 2005 at 13:06:47 Pacific OS: XP CPU/Ram: 512
Comment:
I have an Excel sheet I need people to put data into. The problem I am facing is I need them to be able to put Alpha Numeric and spaces but not allow punctuation. Does anyone know if this can be done? I have a VB script that does not work if people put in punctuation.
Name: Joost Date: June 2, 2005 at 13:43:30 Pacific
Reply:
It seems you use the input for calculation, besause a script can certainly deal with strings? Anyway,you can connect the cell through validation with a list of "standard" data. Look under Data/Validation, choose list an you can point to a range of your own making. Also you can put in =listname, where the listname is the name you gave to a list, Look under Insert/Name/Define. You can create error messages and all. Have fun
Summary: does anyone know how i can set up data validation in Excel XP so that people can only input a figure in minutes? with a maximum of 60 minutes being allowed (this is for lunchtime) ...
Summary: how to insert blank space in data validation list in excel 2007. I'm aware i can choose a range withh a blank cell, i'm looking to type the value in the box. ...
Summary: Excel Data Validation: The following Formula will determine if the data entered into a cell (D3) is a Capital "Y". If so it will allow it, otherwise report an error. =EXACT(D3, UPPER("Y")) That part o...
0 
Outlook 2003 not send lar...
