Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 15th 14, 02:12 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 4
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A macro that will inable/disable input message boxes by a cell'svalue [email protected] Excel Programming 2 May 4th 09 07:32 PM
Disable Pop up "Continue typing in Office 2003 menu key sequence.. Can Elber Excel Discussion (Misc queries) 0 April 1st 09 09:54 PM
Permanently Disable Auto Formatting of Cell Content Lazzaroni Excel Programming 3 October 31st 06 11:00 PM
How do I input a minus time in an excel spreadsheet Nadine NZ Excel Worksheet Functions 1 May 11th 06 11:46 PM
Can I auto fill a cell in one worksheet by typing a code number Gomer Pyle Excel Worksheet Functions 1 August 27th 05 01:24 AM


All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017