The only way to do it is to select the 2 in CO2 then
Format Cells then checkmark Subscripts.

When you select the cell, do not use the address bar. You
have to double-click the cell and highlight the number
only then format it as subscript. You can change its font
size and color too.

Do not tell anyone. This is a secret worth thousands of
dollars.



- mark

How about select the number then change the fon
-----Original Message-----
the same way as in Word, for example, when typing CO2, it
will automatically
change to CO(subscript)2

I know how to do that with symbol in AutoCorrect fuction,
but no idea with
subscript...

anybody?
.