Skip to Content

number to exponential format in mapping

Hi Experts,

I want to convert number to exponential format. (Example number 254 to 2.5400000000E+01), is this possible using FormatNumber function??? if not can you anyone provide me UDF for this.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 04, 2011 at 03:34 PM

    You can try using UDF as follows. See that helps

    Example

    double d = 34.5;
    double dconv = Math.exp(d);

    or use decimalFormat to achieve this.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 04, 2011 at 03:35 PM
    Add comment
    10|10000 characters needed characters exceeded