| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL CELL PROTECTION
I WANT TO ENTER ONLY TEXT IN EXCEL CELL NOT NUMBER
I WANT TO PROTECT THE CELL FROM NUMBER NOT FROM TEXT IS IT POSSIBLE PLEASE GIVE ME SOLUTION FROM PRASAD |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL CELL PROTECTION
Prasad
First, upper case in posts is like shouting and considered rude. While in A1, go to DataValidationAllow dropdown, 'custom' and type a formula of... =ISTEXT(A1) You can highlight your cells first and then type the reference to the activecell. The rest will update automatically -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "PRASAD" wrote in message ... I WANT TO ENTER ONLY TEXT IN EXCEL CELL NOT NUMBER I WANT TO PROTECT THE CELL FROM NUMBER NOT FROM TEXT IS IT POSSIBLE PLEASE GIVE ME SOLUTION FROM PRASAD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
| I want to use a formula in excel to highlight a cell 30 days prio | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
