Is there a way to only have certain things typed into a cell?

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

Guest

Is it possible to have only "P3 000" the "0" means any digets, not more than
3 tho. be the only thing able to be entered?
 
Big Abalone said:
Is it possible to have only "P3 000" the "0" means any digets, not more than
3 tho. be the only thing able to be entered? What I mean is I only want some one to be able to enter "P3 and then one , but not more than 3 digits. For example P3 111 or P3 2, or P3 45. It is for a template for my dive spots.
Click to expand...
 
you could have data validation set in say cell A1 to allow whole numbers
between 1 and 999,and in another cell type ="p3"&a1
 
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

Filter certain cells 1
Protect Only Certain Cells 2
only want certain answers allowed to be entered in a cell 5
Can you only merge up to a certain number of cells 2
Calculate Sum in one cell after Exiting (ENTER or TAB) another cel 2
Excel - prevent someone from clicking into certain cells 1
How to seperate a text group in once cell into many cells 2
Make row white unless the value of a certain cell is >0 6

Back
Top