software

It would be bery useful that Excel could allow make a custiom format about
scientific notation where the exponent could be defined by user. For example,
it coud be exclent that Exel could accept notantion like quot;54.42 E 9quot;, when in
ths moment Excel noly allows one digit before the dot.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

quot;Gamalielquot; gt; wrote in message
...
gt; It would be bery useful that Excel could allow make a custiom format about
gt; scientific notation where the exponent could be defined by user. For
gt; example,
gt; it coud be exclent that Exel could accept notantion like quot;54.42 E 9quot;, when
gt; in
gt; ths moment Excel noly allows one digit before the dot.

Have you tried custom formats such as ##0.00E 0 or ###.00E 0 ?
--
David Biddulph