How do I format a cell so that only specific numbers can be enter.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to format a cell so that only specific numbers can be entered. For
instance only numbers between 1 and 5 can be entered. All other numbers will
either force an error message or simply cannot be entered.
 
Hi Jim

check out data / validation
(choose whole number - between 1 & 5 ... you can also write your own error
messages on the error alter tab)

check out
www.contextures.com/tiptech.html

for additional details on using Data Validation

Cheers
JulieD
 
You must log in or register to reply here.

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

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Conditional formatting in Excel 2010 2
How do I stop Excel from copying date format from cell above? 2
Excel Conditional Formatting 1
Eliminating "#VALUE!" for a formula’s results 1
Help to validate MULTIPLE numbers in one cell, not just the total 1
Excel JUMP FROM SEARCH BAR TO RESULT 3

Back
Top