fixed length character fields
Posted by Rich on October 24, 2001 9:16 AM
I was wondering if there was a way to create a fixed length character column in Excel.
I created an Excel template for users to input data in different columns that would be imported into the DB.
the problem is that some of the DB fields are acertain length.
Is there a way to restrict the data input from a user to only a certain number of characters in a column? For example, if the user keyed in "Hello" and the fixed length was only 2 char, Excel would only accept "He"
I've tried formatting and Condition Formatting the columns but to no avail. Perhaps I'm approaching this the wrong way.
Any suggestions would be greatly appreciated.