Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel treating text as function
I am writing an Excel app in which the user needs to enter dashes
frequently ('-'). However, Excel thinks the user is trying to enter a function, and if the user presses the down arrow, Excel inserts a reference to that cell instead of moving down to that cell. Is there any way to tell Excel not to expect a function? Setting the cell's format to text doesn't work, and the Worksheet_Change event doesn't fire until the user is finished editing the cell. Maybe there is some property in the Application object I can set to fix this? TIA, - Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table treating numbers as text in value field | Excel Worksheet Functions | |||
2007 treating Text as a Number | New Users to Excel | |||
If Function Treating Answer as a Text Box and Not a Numeric Box | Excel Discussion (Misc queries) | |||
How do I stop Excel from treating blank cells as zero? | Excel Worksheet Functions | |||
How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) |