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
 
Top