Skip to Content

How to get a database column value in scientific notation as number format in Excel?

I have a database column of type floating point that I want to display in a report. The original report used the Rounding and Decimal format options to determine how to display the value in standard notation. These options came from another database field. When the report was generated to an Excel file, Excel knew the resultant cell was a number. Fine. Now, I need to enhance the formatting options to allow for scientific notation. Searching this forum led me to believe this was not something that could be done directly, instead I would need to create a formula to whip up the value as a string with the appropriate exponent, etc. I have done this, and replaced what used to be simply a database column in the report with a formula that formats the value in either standard or scientific notation. This works fine also. However, when I output the report to Excel, Excel now thinks the cells containing these values are strings, not numbers. How can I have Excel think these cells are numbers?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 08, 2013 at 04:32 PM

    Hello Leslie

    What version of CR are you using?

    I believe that simply adding the field to a formula will automatically format a long number to scientific notation. E.g.; if I create a formula and add a number to it (1234567890123456789), it is automatically converted to scientific notation. I don't have a database handy with such a large number, but the same would be expected with database fields(?).

    - Ludek

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello

      The answer to the question:

      is there any way I can use my formula for formatting these numbers, and then when I export the report to Excel have Excel think their format is number?

      will be "no". However, let me ask some of the CR design "heavies" 😊 around here re. possible work-arounds of other solutions / approaches and get back to you.

      - Ludek

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.