Excel Tips - Display numbers in Scientific (Exponential) form

-
The Scientific format displays a number in exponential notation.
For example, a 2-decimal scientific format displays 12345678901 as 1.23E+10

How to get a number displayed in Scientific/Exponential Format?

Select the cell(s) which contain the number(s) which need to be displayed in exponential format and then select the format "Scientific" as shown in the below screen shot.




Use the "Increase Decimal" & "Decrease Decimal" buttons (in the red box below) to be able to display the complete number.

Below is the end result after increasing decimal places for the first number.




How to get a number currently displayed in Scientific/Exponential Format to be displayed in normal format?


If you input any number in an excel cell with 12 digits or more, excel will display that in the exponential format. 

In our example the number is "1234567891012" and excel displays it in the exponential format as shown below:

To remove the exponential format, change the display format to "Number" and then decrease the decimal places using the "Decrease Decimal" button.





Comments

Post a Comment

Popular posts from this blog

SAP ABAP - Generating Excel file for downloading or sending over email

-
Creating excel content from data in an internal table?  Getting the following message when opening an excel created out of SAP - "The file you are trying to open, ‘filename.xls’ is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?" Below is the best solution. This solution is based on the approach used by standard SAP to created excel content from ALV. Once any ALV is displayed, you can get the data into excel using the menu bar option LIST -> EXPORT -> SPREADSHEET.  If there are any questions, put them in the comments.  Sample working code: *&---------------------------------------------------------------------* *& Report Y_EXCEL *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT  Y_EXCEL ...
Read more

Get your signature from a paper to word document

-
Image
Follow the below steps to your signature from a physical hard copy onto a word document. Also ensuring that the background matches. Step 1: Put your signature on a piece of paper and take a snap of it with your mobile camera. Below is what you will have    Step 2: Open a word document that would basically have contents of a letter that you are drafting needing your signature on it and paste the signature pic from step 1 in the appropriate location. Step 3:  The next step is to ensure that the background of the signature is changed so that it matches with the rest of the content on the word document. Right-click on the image and select 'Format Picture' Go to the option of 'Picture Corrections' and set the contrast as '100' The end result is the following:
Read more