If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
set a maximum number of characters in a cell?
i want to set up a database so that each cell has a limit of 30 characters,
so that each address is no more than 30 characters long. |
#2
|
|||
|
|||
Hi
You can have a macro chop off the exceeding characters immediately after the entry is done. 30 first, 30 last ? But you can do absolutely nothing while people enter into cells or control which kinds of entries cells accept., and you can not guarantee that macros are enabled to run by the user. HTH. Best wishes Harald "Peck" skrev i melding ... i want to set up a database so that each cell has a limit of 30 characters, so that each address is no more than 30 characters long. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I expand the number of characters allowed in an Excel cell. | Mizlabelle | General Discussion | 5 | September 1st, 2004 10:25 PM |
Removing blank characters in a cell | Roger Govier | Worksheet Functions | 14 | February 11th, 2004 06:51 AM |
Data Validation Query - How do I stop data being input in a cell once maximum characters are reached? | Colin | Worksheet Functions | 1 | January 3rd, 2004 11:09 PM |
Formula help | Wally | Worksheet Functions | 6 | December 5th, 2003 12:18 PM |