| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to only have certain things typed into a cell?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to only have certain things typed into a cell?
"Big Abalone" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to only have certain things typed into a cell?
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 -- paul remove nospam for email addy! "Big Abalone" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum in first blank cell and a few more things... | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
