Disable auto-input of cell when typing a minus

B

bunalz

I'm using Excel2007. For this case, I'm not using it to do an
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 (-), Exce
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 th
sign. However, as it is possible to input data directly into a cell, i
would be unnecessary for me to press 'Enter' and just navigate to othe
cells with the arrow keys easily.

I'm wondering if it is possible to do that
 

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

Top