Excel anomaly

isonomicjedi · 19 Jun 2013 at 10:33

I was working on Excel last night and wanted to label a column ADN but I've found that every time I type ADN into a cell it amends it to AND.

I thought I must have done some strange formatting I never new existed so tried in a new workbook and hey presto the same thing happens.

I've overcome this by labelling it *ADN* but thought I would share this with you all.

geuben · 19 Jun 2013 at 11:18

File > options > Proofing > auto correct

Find and delete the entry for "adn" -> "and"

isonomicjedi · 19 Jun 2013 at 13:08

Ah! Many thanks for that.

Been using excel for years and never came across that before.

Narj · 19 Jun 2013 at 13:38

I find it highly amusing to modify entries in work colleagues' settings from "can't" to **** (rhymes with 'punt') when they leave PCs unlocked.

They normally send out at least one email before noticing.