how do you format a number such as 6.9 if you want the 9 to look .
 

how do you format a number such as 6.9 if you want the 9 to look smaller than
the 6 and at the top right side of it ?

thanks

Doesn't work on numbers, you have to precede the number with an apostrophe or
format the cell as text first, and then you can select just that part of the
string and format as Superscript.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"RALPH" wrote in message
...
how do you format a number such as 6.9 if you want the 9 to look smaller than
the 6 and at the top right side of it ?

thanks


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.808 / Virus Database: 550 - Release Date: 08/12/2004

Just to clarify, when I say doesn't work on numbers, I mean you can't apply it
to just part of a number. You can always format the entire cell as superscript,
although that isn't what you want obviously.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Ken Wright" wrote in message
...
Doesn't work on numbers, you have to precede the number with an apostrophe or
format the cell as text first, and then you can select just that part of the
string and format as Superscript.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"RALPH" wrote in message
...
how do you format a number such as 6.9 if you want the 9 to look smaller than
the 6 and at the top right side of it ?

thanks


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.808 / Virus Database: 550 - Release Date: 08/12/2004



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.808 / Virus Database: 550 - Release Date: 08/12/2004