"E" for powers of 10

Question

Hello,

For a publication in a scientific paper I made graph under JMP (file attached). Editor asks me to change the "E" for powers of 10. In other words, 3.4 × 10⁵ instead of 3.4e+5. Could you please tell me if there is an easy way to do this ?

Thanks in advance,

best regards

Sébastien

puissance.JPG

Jonas_Rinne · Answer

Nice, wished I new that earlier...

just leaving this here in case someone is looking into this thread after the JMP 18 release:

MRB3855 · Answer

Hi @Emmerich38  @Craige_Hales  @Jonas_Rinne : and, this was discussed here recently. 
https://community.jmp.com/t5/Discussions/How-change-quot-E-quot-for-powers-of-10/m-p/725165#M90925

Craige_Hales · Answer

You can use a JMP 17 custom format to do it. (Test this code to make sure it does what you want!) Copy this

If(
	Pat Match(
		Format( :value, "Scientific", :width ),
		Pat Pos( 0 ) + Pat Immediate( Pat Break( "e" ), f ) + "e"
		+Pat Immediate( Pat Rem(), e )
	),
	f || "⨉10" || Substitute( e,
		"+", "⁺",
		"-", "⁻",
		"0", "⁰",
		"1", "¹",
		"2", "²",
		"3", "³",
		"4", "⁴",
		"5", "⁵",
		"6", "⁶",
		"7", "⁷",
		"8", "⁸",
		"9", "⁹"
	),
	Char( :value, :width, :dec )
)

Then open the axis dialog, Format->custom, set custom, paste.

The custom format uses the scientific format to make the "e" format then parses the fraction and exponent. It then reassembles the number with some Unicode characters. If you are not seeing exponents and multiplies and signs, your font might not include them. If the parse step fails, the custom format falls back to the char() function.

edit: @XanGregg  post Reply All: Scientific notation such as 6.02×10²³ using custom axis formats