| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Format Cell (Number Custom)
I want the user to only be allowed to enter the Char type 'A' or 'D' in this
particular cell. Does any know how to accomplish this? |
|
#2
|
|||
|
|||
|
Does Char type 'A' or 'D' mean the characters A or D?
If yes, take a look at Data|Validation. It isn't foolproof (users can paste over the cell), but it works nicely for most. barryderay wrote: I want the user to only be allowed to enter the Char type 'A' or 'D' in this particular cell. Does any know how to accomplish this? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Number (custom) | Excel Discussion (Misc queries) | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| number format keeps dividing by 100 | New Users to Excel | |||
| multiply by actual number in cell | Excel Worksheet Functions | |||
Linear Mode
