Cell Limitation

[benlee]

Morning,
I am trying to use excel to create a templete that can be filled in and
exported into our accounting software.
Our software restricts the number of digits in certain fields.

Is there a way that I can restrict the number of letters that can be entered
in a cell to replicate the accounting software??

Many thanks

Lee.

[y_not]

Data>Validation and select from the options

Regards

Tony

[benlee]

Thanks Tony,
Thats a great help!!!

"y_not" wrote:

>
> Data>Validation and select from the options
>
> Regards
>
> Tony
>
>
> --
> y_not
> ------------------------------------------------------------------------
> y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
> View this thread: http://www.excelforum.com/showthread...hreadid=525169
>
>