Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RALPH
 
Posts: n/a
Default 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
  #2   Report Post  
Ken Wright
 
Posts: n/a
Default

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


  #3   Report Post  
Ken Wright
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
number formats that allow you to format the appearance of negativ. jassmon Charts and Charting in Excel 1 January 15th 05 09:04 AM
excel format cells/Number/Category: Number problem Matts Excel Discussion (Misc queries) 5 December 9th 04 09:47 PM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 7th 04 11:02 PM
Import Indian Rupees as a number format in Excel Aditya Khandekar Excel Discussion (Misc queries) 2 December 6th 04 03:48 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"