AnsweredAssumed Answered

creating a scientific notation format in custom number formats

Question asked by hbowen12 on Mar 16, 2015

I am trying to create a custom number format that it scientific notation and only has two numbers after the e (ex. 9.88e+08). The scientific notation format allows you to change the number of decimal places on the actual number, but not after the e, and gives three numbers after the e (ex. 9.88e+008).

 

In the custom tab I used the string 0.00E+00. This works correctly in excel, but in ArcMap it gives 988000000.00E+00.

 

Does anyone know why is isn't reading the string formula correctly, or how I can get my values to only have two numbers after the e?

Outcomes