LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 329
Default Superscripted exponents

Numbers like '1E+00' are numbers expressed in scientific notation and pre-date computers - so nothing to do with "computerese".

In an Excel cell, you can only superscript part or all of a text string, or *all* of a number entered into that cell.
In an Excel textbox, you can superscript part or all of a text string or part or all of a number entered into that textbox.
You cannot superscript just a part of anything returned by a formula (i.e. either a number or a string), whether in a cell or a
textbox.

Cheers

--
macropod
[MVP - Microsoft Word]


"hmm" wrote in message ...
| I would like to display superscripted exponents in my charts and tables, as
| they appear in texts, instead of the computerese "1E+00" notation.
|
| Does anyone know how? I use Excel 2000.


 
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
Excell: Add superscripted footnote beside a number i.e. 10,000 1 Craig Jr New Users to Excel 1 May 19th 06 07:59 PM
How can you format so you could write x squared using exponents? Susan Kerlin Excel Discussion (Misc queries) 2 January 23rd 06 05:39 PM
I wish to display numbers in engineering format (exponents * 3). engineer2 Excel Discussion (Misc queries) 1 December 1st 05 12:03 AM
sum of a series of exponents sirsoto Excel Worksheet Functions 2 July 5th 05 08:57 PM


All times are GMT +1. The time now is 08:06 AM.

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"