Superscript using VBA

**iluvfnky** · 11-16-2010, 07:39 PM

Hi, I would like to format a cell to superscript the € symbol and .00 on a price using VBA. Eg. €100.00 where the 100 stays normal. Any ideas?

**shg** · 11-16-2010, 07:51 PM

Try recording a macro.

You can only do this if the cell contains a literal value, not a formula.

**iluvfnky** · 11-16-2010, 07:58 PM

Thanks shg, but it's a formula hence the need for a VB code.

**shg** · 11-16-2010, 08:06 PM

If it's a formula, it's not going to happen in any fashion.

Re: Superscript using VBA