Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 15th 14, 03: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?

  #2   Report Post  
Old Yesterday, 05:15 AM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 13
Default

You need VBA .


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 November 1st 06 12:00 AM
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 04:08 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017