Oddity with HSI

M

Mike

Does anyone know why you cannot enter the letters HSI into a cell? it will
change them to HIS. However, a line of code will enter HIS:
ActiveCell.Value = "HIS"

Mike F
 
D

Dave Peterson

Tools|autocorrect options|autocorrect tab
remove the hsi from that list at the bottom.

Or hit ctrl-z as soon as excel jumps in with the autocorrection.
 

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

Insert name and adress from a list in a word document 1
HSI becomes HIS when saved 4
how to change "hsi" to "his" 1
How to set default not to auto correct word? 1
Need Help with Macro Security 1
HSI in data cell is auto correcting to HIS 1
EXCEL refuses to recognize the text HSI - auto changing it to HIS 1
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4

Top