Presentation of large numbers on a grapg axis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gonzo - 29 Oct 2006 15:15 GMT

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?

Signature

gonzo

Reply to this Message

Andy Pope - 29 Oct 2006 15:41 GMT

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

> 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?

Signature

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

Reply to this Message

gonzo - 30 Oct 2006 16:07 GMT

Tnx Andy
Huge help

Signature

gonzo

> Hi,
>
[quoted text clipped - 12 lines]
> > I woulkd like it to be 1.3 * 10 3 and the 3 in uppercase - like in WORD.
> > Any idea?

Reply to this Message