Formating cells
 

Hi,

need a help with cell formating.
Would like to format cells so user cannot input more than 10 caracters into
a cell and than 4 rows with 15 caracters into each cell possible input.
Is this easy to do with excel?

Thanks all
BT

Formating cells
 

Hi,

Yes, use data validation (Data/Validation). Start by selecting the cells
with the same restrictions (10 characters) then go to Data/Validation, select
"Custom" from the drop down menu and type =LEN(A1)<=10 (where A1 is the
active cell) , next click on the "Error Alert" tab and leave a message
stating that 10 is the maximum character that can be typed in that cell.

Repeat for the 15 characters cells and so on......


HTH
Jean-Guy

"BT" wrote:

Hi,

need a help with cell formating.
Would like to format cells so user cannot input more than 10 caracters into
a cell and than 4 rows with 15 caracters into each cell possible input.
Is this easy to do with excel?

Thanks all
BT

Formating cells
 

"pinmaster" wrote in message
...
Hi,

Yes, use data validation (Data/Validation). Start by selecting the cells
with the same restrictions (10 characters) then go to Data/Validation,
select
"Custom" from the drop down menu and type =LEN(A1)<=10 (where A1 is the
active cell) , next click on the "Error Alert" tab and leave a message
stating that 10 is the maximum character that can be typed in that cell.

Repeat for the 15 characters cells and so on......


HTH
Jean-Guy

"BT" wrote:

Hi,

need a help with cell formating.
Would like to format cells so user cannot input more than 10 characters
into
a cell and than 4 rows with 15 characters into each cell possible input.
Is this easy to do with excel?

Thanks all
BT




Thank this works fine :-)
Just another thing, is possible to count the characters down while entering
into cell so I can see how many characters are possible to enter.
BT

Formating cells
 

Hi,

As far as I know No. But I'm not an expert, it might be possible with VBA.
I'm sure someone will let you know if it is.

Best wishes!
Jean-Guy

"BT" wrote:


"pinmaster" wrote in message
...
Hi,

Yes, use data validation (Data/Validation). Start by selecting the cells
with the same restrictions (10 characters) then go to Data/Validation,
select
"Custom" from the drop down menu and type =LEN(A1)<=10 (where A1 is the
active cell) , next click on the "Error Alert" tab and leave a message
stating that 10 is the maximum character that can be typed in that cell.

Repeat for the 15 characters cells and so on......


HTH
Jean-Guy

"BT" wrote:

Hi,

need a help with cell formating.
Would like to format cells so user cannot input more than 10 characters
into
a cell and than 4 rows with 15 characters into each cell possible input.
Is this easy to do with excel?

Thanks all
BT




Thank this works fine :-)
Just another thing, is possible to count the characters down while entering
into cell so I can see how many characters are possible to enter.
BT

Formating cells
 

"pinmaster" wrote in message
...

As far as I know No. But I'm not an expert, it might be possible with VBA.

VBA won't/can't run while you are in edit mode

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"pinmaster" wrote in message
...
Hi,

As far as I know No. But I'm not an expert, it might be possible with VBA.
I'm sure someone will let you know if it is.

Best wishes!
Jean-Guy

"BT" wrote:


"pinmaster" wrote in message
...
Hi,

Yes, use data validation (Data/Validation). Start by selecting the
cells
with the same restrictions (10 characters) then go to Data/Validation,
select
"Custom" from the drop down menu and type =LEN(A1)<=10 (where A1 is the
active cell) , next click on the "Error Alert" tab and leave a message
stating that 10 is the maximum character that can be typed in that
cell.

Repeat for the 15 characters cells and so on......


HTH
Jean-Guy

"BT" wrote:

Hi,

need a help with cell formating.
Would like to format cells so user cannot input more than 10
characters
into
a cell and than 4 rows with 15 characters into each cell possible
input.
Is this easy to do with excel?

Thanks all
BT




Thank this works fine :-)
Just another thing, is possible to count the characters down while
entering
into cell so I can see how many characters are possible to enter.
BT