This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Convert a decimal to scientific notation

Posted on 10-19-2024 09:26 PM
open3d
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hello,

I'm currently working in a project and I have 2 columns that display a decimal value by a given formula.

my formula is: (POWER((7000/[Film Stress]),9))*1000000 and the value it displays is a type decimal being this number: 193,804,516.4285058000.

I'd like for that value to be 1.93804516429e8 

I have another decimal value in a different column formula is:

(POWER((1.0/(2.0*3.1415926*[1 / Pulse Width or Ringing Frequency])),2.0))/([Desired Capacitance in µF]/1000000)

that actually converts itself to scientific notation whenever I change it from decimal to text however this value has more decimals so I think appsheet automatically converts it if it has many more decimals.

I attached a picture to show you how it displays both values in the top and bottom.

Screenshot 2024-10-19 at 9.24.15 PM.png

0 2 140
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM
@open3d wrote:

that actually converts itself to scientific notation whenever I change it from decimal to text however this value has more decimals so I think appsheet automatically converts it if it has many more decimals.

AppSheet does not have any direct support for Scientific Notation.   That "automatic conversion" is likely happening in the Google sheet.   Google sheets will automatically convert large numeric values in sheet column that have a format setting of "Automatic".  See image below.

You may be able to leverage this "feature" for your purposes.  If you need to perform calculations on the formatted numbers, you may be able to use sheet-side formulas to do it.  (This would be one of the very rare instances to do that.)  These can get messy as you build out the app.  A better approach would be to create a Google app script to perform your calculations.


Google Sheet converting large number to Scientific Notation.

<< image coming shortly >>

 

Posted on --/--/---- --:-- AM
open3d
Bronze 3
Bronze 3
In response to WillowMobileSys
Reply posted on --/--/---- --:-- AM

Thank you for your response, since I'm exporting the final results to a PDF, I just formatted the XLSX cell to Scientific and it automatically converts it from the appsheet form cell to scientific so for now that works.