How to remove validation on entering - into a cell.

S

shiprasharma

When i select a cell in Excel Sheet and enter - (dash/minus) sign.After
clicking on sheet it will convert the previous cell into a formula
(since it takes - as formula for any format selected), indicating cells
index. How i validate a cell not to perform the above feature.
On pressing tab or enter key will solve the probs for text format but
how i validate it for the same i.e. on what event? :confused:
 
J

Jerry W. Lewis

Either preformat the cell as text or prefix the entry with a single quote.

Jerry
 

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

In-cell dropdown dependent on cell value (Data Validation) 1
Data Validation - Allow "" in Number Cell 15
Data Validation using ISBLANK with non-contigious cells 2
Where was I before pressing enter/return or tab key 1
Data Validation - Again! 5
Converting excel to PDF, single page converts to multiple HELP! 1
unable to add row to Excel 2007 TABLE 3
Help needed with Data Validation. 5

Top