View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Gonzo Gonzo is offline
external usenet poster
 
Posts: 6
Default 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