Cell Limitation
 

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.

Cell Limitation
 

DataValidation 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

Cell Limitation
 

Thanks Tony,
Thats a great help!!!

"y_not" wrote:


DataValidation 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