ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "BVE as text entry" (https://www.excelbanter.com/excel-worksheet-functions/51146-bve-text-entry.html)

sdtech

"BVE as text entry"
 
Why am I unable to key in BVE as a cell entry?? Everytime I key in BVE (I use
this as an abbreviation of a product name) and the "E" disappears. What is
the cause of this?

Ron Rosenfeld

"BVE as text entry"
 
On Tue, 18 Oct 2005 19:23:04 -0700, sdtech
wrote:

Why am I unable to key in BVE as a cell entry?? Everytime I key in BVE (I use
this as an abbreviation of a product name) and the "E" disappears. What is
the cause of this?


Tools/Autocorrect Options

Type in BVE in the Replace Box and I'll wager you'll see "be" in the With box.

You can delete it.
--ron

Jezebel

"BVE as text entry"
 
It's an AutoCorrect entry. You can delete it (Tools AutoCorrect). Or
reselect the cell and enter the missing character. (It's the key sequence
that AutoCorrect is modifying, rather than the cell value.)



"sdtech" wrote in message
...
Why am I unable to key in BVE as a cell entry?? Everytime I key in BVE (I
use
this as an abbreviation of a product name) and the "E" disappears. What is
the cause of this?




Bob Umlas

"BVE as text entry"
 
Wow! Nice find! After it changes to BE (for me the "V" disappears), you can
click in the formula bar and reenter the V.
Weird!

"sdtech" wrote in message
...
Why am I unable to key in BVE as a cell entry?? Everytime I key in BVE (I
use
this as an abbreviation of a product name) and the "E" disappears. What is
the cause of this?




Bob Umlas

"BVE as text entry"
 
Damn! Stupid me! No problem - I should have known that!! (autocorrect)
"Bob Umlas" wrote in message
...
Wow! Nice find! After it changes to BE (for me the "V" disappears), you
can click in the formula bar and reenter the V.
Weird!

"sdtech" wrote in message
...
Why am I unable to key in BVE as a cell entry?? Everytime I key in BVE (I
use
this as an abbreviation of a product name) and the "E" disappears. What
is
the cause of this?







All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com