Hi,

You can't actually do that with straight formatting. If you enter 421st in
a cell and to format it you will need to select the st portion of the entery
and choose Format, Cells, Font tab, Superscript. Now fill it down and you
will see what Excel can do.

You could write a macro to do this, but you can't use a formula approach
because Excel does not allow you to format part of a formula.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Jokah.D" wrote:

I would like to represent numbers as placements for example: 421 becomes
421st with the "st" in superscript, 32 becomes 32nd with the "nd" in
superscript.

Is there a way to do this in Excel 2007?