Presentation of large numbers on a grapg axis
 

I would like to present large numbers on an graph axis , but not in the
formal engineering format - like , let say i have the number 1300
the usual engineering presentation is = 1.3E+3
I woulkd like it to be 1.3 * 10 3 and the 3 in uppercase - like in WORD.
Any idea?

--
gonzo

Presentation of large numbers on a grapg axis
 

Hi,

Use a custom number format.

0.0,"*10³"

to get the superscript 3 use ALT+0179 (use numeric keypad to type 0179)

Cheers
Andy

gonzo wrote:
I would like to present large numbers on an graph axis , but not in the
formal engineering format - like , let say i have the number 1300
the usual engineering presentation is = 1.3E+3
I woulkd like it to be 1.3 * 10 3 and the 3 in uppercase - like in WORD.
Any idea?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Presentation of large numbers on a grapg axis
 

Tnx Andy
Huge help

--
gonzo


"Andy Pope" wrote:

Hi,

Use a custom number format.

0.0,"*10³"

to get the superscript 3 use ALT+0179 (use numeric keypad to type 0179)

Cheers
Andy

gonzo wrote:
I would like to present large numbers on an graph axis , but not in the
formal engineering format - like , let say i have the number 1300
the usual engineering presentation is = 1.3E+3
I woulkd like it to be 1.3 * 10 3 and the 3 in uppercase - like in WORD.
Any idea?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info