Why won't Excel let me write BVE in a cell (Book Value of Equity)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to write BVE in a cell in excel. It instantly changed it to BE.

I tried changing the cell to a text cell, but that still didn't allow me to
write BVE.

What's going on?

Any idea?

Thanks

Michael
 
Michael,

It is the auto correct feature that corrects common typos. If you go into
Tools | Auto Correct Options and type "bve" into the Replace box you'll see
that it is set up to auto correct that presumed typo with "be". You can
delete this correction or simply uncheck the "Replace text as you type"
option box. This will not affect the spell check from picking up "bve" and
offering "be" as the correction.

Cordell
 

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

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Trying to Locate position of a DASH "-" in Cell or String 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Making a cell Mandatory 9
Excel Can you lock the value of a cell but not the format? 1
Excel Stop Excel from displaying rounded values 4

Back
Top