How to limit number of characters in the cell

T

Toman

Hello guys,

I want to ask you for a small advice.

What should I do If I want to limit the number of characters/numbers i
the cell.

For instance: I have column named "phone numbers" and I want to inser
only numbers which consist of 6 numerals (it means that max cell valu
is999.999)

Many thanks and best regard
 
B

bplumhoff

Hello Toman,

Have a look at Data / Data Validation

You can define a) valid text length b) valid interval etc.

HTH,
Bernd
 
E

EdMac

Hi Toman,

Easiest way is Data>validation> whole number > between and then enter
the min and max eg 100000 and 999999.

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Cell input control 3
Limit number of characters in a cell 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Restricting more than x number of characters in a cell.... 1
Comparing characters in cells 7
Strip non numeric characters from a cell 13
How to limit # of characters in a cell? 2

Top