K
KelliInCali
I'm wondering how I can check settings for when Office auto-formats, for
instance, a fraction.. making it smaller. Also with "th" and "nd" like 16th
and 2nd.
I have noticed that it does this with some new text or cells and not with
others, and I can't figure out how it is making the differentiation. It is
bothersome for consistency. For instance, I can type '1/2" length' as text
in one cell, and Excel reformats the 1/2, but then typing '3/4" length' in
the cell below it does not reformat.
I tried the AutoCorrect options on the Options/Spelling tab, but numbers are
not part of that library.
Anyone?
instance, a fraction.. making it smaller. Also with "th" and "nd" like 16th
and 2nd.
I have noticed that it does this with some new text or cells and not with
others, and I can't figure out how it is making the differentiation. It is
bothersome for consistency. For instance, I can type '1/2" length' as text
in one cell, and Excel reformats the 1/2, but then typing '3/4" length' in
the cell below it does not reformat.
I tried the AutoCorrect options on the Options/Spelling tab, but numbers are
not part of that library.
Anyone?