Disable auto-input of cell when typing a minus
I'm using Excel2007. For this case, I'm not using it to do any calculations; rather just a data listing (with repeated cell values: Thus, MsAccess is out of option).
To explain properly, whenever one types in a minus/dash sign (-), Excel will automatically insert the "name" of the highlighted cell (e.g. A1, B2, etc).
Setting the data as 'Text', I could have just press 'Enter' to input the sign. However, as it is possible to input data directly into a cell, it would be unnecessary for me to press 'Enter' and just navigate to other cells with the arrow keys easily.
I'm wondering if it is possible to do that?
|