ExcelBanter - Number formatting in EXCEL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Number formatting in EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/94675-number-formatting-excel.html)

Othman

Number formatting in EXCEL

Hi
I want to format numers in the form of m x10^n (n is a suberscript without
^) instead of the scientific form mEn available in EXCEl. it that possible?
Thanx

Jerry W. Lewis

Number formatting in EXCEL

That is the meaning of the xEn format (scientific notation), but I know of no
Excel format that will display in the way that you want.

Jerry

"Othman" wrote:

Hi
I want to format numers in the form of m x10^n (n is a suberscript without
^) instead of the scientific form mEn available in EXCEl. it that possible?
Thanx

All times are GMT +1. The time now is 02:32 PM.