Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting a Column to "X" Number of Characters
Is there a way to limit a column to 33 characters in length? We are using
Excel 2003. Thanks for any help. Wayne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting a Column to "X" Number of Characters
use data -- validation
Select on box allow: Text length Data: Less than Maximum 33 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Wayne" escreveu: Is there a way to limit a column to 33 characters in length? We are using Excel 2003. Thanks for any help. Wayne |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting a Column to "X" Number of Characters
Is there a way to limit a column to 33 characters in length? We are
using Excel 2003. Thanks for any help. Wayne use data -- validation Select on box allow: Text length Data: Less than Maximum 33 Be aware though, that data validation works only for typed-in values. Somebody can paste in a value that violates the limit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
The number of characters in a "Screen Tip" | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
FIND is not "finding" a number in a column which contains the numb | Excel Worksheet Functions |