limit # of chars in a cell

S

soonic

Hi

My question is: how to limit a number o characters in a cell? I'd like make
for example col A to be able to write only 8 chars per cell and only text or
only numbers.

s.
 
S

Stefi

Try Text length option of Data>Validation!

--
Regards!
Stefi



„soonic†ezt írta:
 

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

FP2003 shows wrong char when load pages 0
Limit the size of a cell 2
Excel does not accept text format! 0
How to make a number have a certain number of characters. 6
Changing the highlighted color of a character 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0

Top