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
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Find text in cell and copy from 4 characters in front of the found text. 2
make Excel see a (one digit) number as text 5
SUMIFS UNTIL the number is repeating 0
SUMIFS ONLY UNTIL the number REPEATS 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5

Top