View Full Version : Data Input Restrictions
mostwantedki
12-09-2010, 09:22 AM
Hi All,
It is possible to restrict each cell only having 40 charcters to enter in Excel.
Please help on this.
very new to this area.
Bob Phillips
12-09-2010, 09:34 AM
Look at Data Validation.
mostwantedki
12-09-2010, 09:40 AM
Hi i guess i tried one of your solution but no luck ...
=AND(ISNUMBER(E1),LEN(E1)=10)
iam very new to this even dont know how use this..
i tried Use Data>Validation with a type of Custom, and a formula of
and press ok still able to enter 13 charter in a column.
Bob Phillips
12-09-2010, 12:00 PM
DV has a Text Length type, you can use that.
mostwantedki
12-10-2010, 01:24 AM
can any body help on this.. still iam unable to do this.
mostwantedki
12-10-2010, 01:32 AM
Hi My requirement was .. data validation needs to be check in all the cells should have only 40 charcters if it is more than 40 charcters it should shown as a different colour in the cell... please help on this.
mostwantedki
12-10-2010, 01:54 AM
i was trying to validate an existing excel it has each cell has more then 40 charcters and i need to validate this for 40 charcters then the other charcters need to show as a different color.
austenr
12-10-2010, 03:25 PM
Data -> Validation -> Text Length -> Less Than or Equal To -> 40
Then either copy that down using paste special or use the format painter, your choice
or using Conditional Formatting
Select A1:A100 range and enter =LEN(A1)>15 in CF formula field and select a background color!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.