Ok, here it is, but remember there's a lot more to the original file than just this one column.



I'm off in a minute to eat & may be back or may go to bed.

Thanks


Michelle

Attached Files

Sample file re auto suggest bug.xlsx (19.4 KB, 12 views)

Not a problem thanks for the heads up. I can only come up with 2 thoughts on what the issue could be. I posted a screenshot of what was happening when I entered in cj. Is this the issue you are experiencing? If this is the issue does it change back to the desired CJ after you press enter like it did for me or does it stay in lowercase?
2nd this may not have any effect at all but I did notice that there is a mixture of Arial and times new roman fonts in the sample causing some CJ's to look a little different I don't think this is at all what you are referring to though. So with that said does this issue continue after you press enter? or does it stay lowercase after you press enter? if it stays lowercase the auto-complete may have inadvertently been turned off. I certainly want to help you with this but these are my only 2 thoughts right now. We will battle it some more tomorrow.

Attached Images

test.jpg (72.7 KB, 14 views)

Hi,

I don't press "enter", I press "tab" to get to the next column.

I tried enter & that didn't solve the problem.

I tried to find where you said the font is different in some cells & couldn't.

I didn't look at every cell of course, but I'm wondering how you saw this & which cells you are referring to.

How can the auto complete be off if it's giving me cJ as an option?

I'm not understanding.

Thanks


Michelle