Excel 2007 - How do I stop the automatically replaced hyphen?

Question

When I type in a normal hyphen, Excel replaces it with a long hyphen that is not the same character. 

In Word, this can be changed in the AutoCorrect settings in the "Auto Format as you Type" box, however in Excel, this box only contains 3 items, none of which is the hyphen.

Any idea where this setting would be located?

Answer 1

Ascii 45 is a regular hyphen.....150 is an en dash.......151 is an em dash.

Reading your original description it sounded like your problem was constant but you say it is random.

Since it is random it would not seem be an autocorrect feature.

Does this occur only in one workbook/worksheet or is it a global occurrence?

If one workbook Is the workbook a macro-enabled workbook.......*.xlsm

If just one sheet and random cells perhaps some event code behind the sheet?

I have no idea where it would be coming from otherwise.

When data is replaced by overwriting you don't usually have leftovers.

Gord

Answer 2

It returns "45" when I type a hyphen into a blank cell.  However, if I go to a cell with the long dash and copy just the dash, it reads "150".

I currently have Calibri selected as the default font.

I am still not sure where the long dash is coming from, but it seems to be random.

Is it possible that it is left over from other data that was replaced?

Answer 3

I am surprised to hear that.

All your Office 2007 applications use the same *.ACL file so if you have eliminated that in Word it should carry over to Excel.

What font type are you using?

Is the hyphen replaced with the em dash in all fonts?

Do you have some code running that might be doing the deed?

Type a hyphen in a cell formatted to Arial font.

In an adjacent cell enter  =CODE(cellref)

Does it return 151 which is the em dash?

Gord

Answer 4

I can not find the hyphen listed, There is no specific check box for it, and it is not listed in the "Replace text as you type" box.

Any other ideas?

Answer 5

Look under Autocorrect Options>Autocorrect Tab.............not Autoformat as you type Tab

Gord