Excel 2010 - Trendline Formula - Scientific Notation - Needs to be more specific. If you don't like it displaying like that, then you can apply a number format to the column that displays, say, 2 decimal places instead. For example, 1,000,000,000 will be formatted into 1.0E+09 when changing it to the scientific format in Excel. ... but are coming out in scientific notation. As you can see, the decimal value should have been 4.97; instead, it shows as 4.98. Changing the field to Note that Excel rounds the value to 2 decimal places. Privacy & Cookies: This site uses cookies. I want to convert a text value to scientific notation form. A number format does not affect the actual cell value that Excel uses to perform calculations. hours of work!”, Your message must be at least 40 characters. Log in Register. Your question will be answered by an Excelchat Expert. Re: When I paste a long number, Excel turns it into scientific notation and changes numbers. The formula in C19 is ="10"&LOG(A19), and it is filled down through C25. When cells are in General format, you can type scientific notation directly. Enter the number, plus "E," plus the exponent. The following formulas also can help you to convert the list of scientific notation to text. MOTHERSS is 9 digits, but should be treated as text. In my experience, once the number is converted, you've lost the original number. I want to see big numbers in same power of scientific notation in microsoft excel. You need to know how negative exponent works with excel scientific notation. Excel thinks it's being helpful by displaying it in scientific notation because it's such a tiny number. Click on this to apply this formatting. We can only change the decimal values like 2, 3, and 4 digits. Figure 1. Now we can see scientific numbers in three-digits. Close Window Get Your Free Excel ebook! Scientific notation in Excel. Core Formula. Now look at A6 cell value, general formatting value was 49758 and scientific value is 4.98E+04 i.e. This problem is caused by Excel which has a 15 digit precision limit. In Excel, you can use the arithmetic sign or the built-in functions to evaluate cells value. Our Excel Experts are available 24/7 to answer any Excel question you may have. Excel Functions are the built-in formulas … Output: So, Sun pulls the Earth with a force of magnitude … Output:  Scientific notation of a value less than zero, Figure 11. The Excel ROUND function returns a number rounded to a given number of digits. There is no way in Excel to change the way in which scientific notation is displayed. Now by selecting the range, click on the drop-down list in excel of “Number Format.”. Local time Yesterday, 23:17 Joined Apr 9, 2002 Messages 201. Latest reviews Search Excel articles. If you don’t want to see this rounding off to the nearest values, then you can increase the decimal value from 2 to 3 digits. Formula: I am having an issue with Microsoft Excel 2010. When we want to enter a value less than zero in scientific format, we add a “minus” sign before the exponent. He would like the scientific notation to be shown differently, such as 1.23x10^3 or 1.23x10^-3. 0. If you want to save hours of research and frustration, try our live Excelchat service! Excel will not let me copy and paste a formula and will only paste the value into to workbook. Scientific Notation Formula When a number is too large, then the scientific notation is used for expressing in shorthand with the use of powers of tens that is universal and easy to manage. Not only are they unattractive, they take up more space, squeezing out valuable plot area real estate. The value in the cell is 0.0000101 and the display in scientific format is 1.01E-05. =TEXT(TODAY(),"MM/DD/YY") Today’s date in MM/DD/YY format, like 03/14/12 =TEXT(TODAY(),"DDDD") Today’s day of the week, like Monday =TEXT(NOW(),"H:MM AM/PM") Current time, like 1:29 PM How to use scientific notation. Open the spreadsheet containing the tracking numbers that are currently displaying as scientific … Now take an example of the first instance. Excel Articles. 1.23E+7 1.45E+10 1.36E+12 as below: 1.23E+7 1453.11E+7 136445.11E+7 (all with E+7 power) Convert scientific notation to text with formulas. Hang tight for 30 secs while we … Please enter this formula: =trim(A1) into a blank cell, B1 for instance, see screenshot: 2. This is noted by Excel putting a green arrow in the top left of the cell. The formulas are written with an equal sign in a cell. I have created a Jrxml to generate an excel output. for free. For example, a 2-decimal scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power. E stands for exponent. Hot Network Questions How do I know the switch is layer 2 or layer 3? Note that Excel will automatically use Scientific format for very large and small numbers of 12 or more digits. Formulas are the key to getting things done in Excel. Excel automatically displays a number having 12 digits or more into a scientific format, even if the cell format is not set as Scientific, Figure 12. It is a notation in Excel. By continuing to use this website, you agree to their use. Re: Trendline equation scientific format Thanks for the quick reply, @PReagan Yes, I need to display the Excel-calculated y=mx+b equation, but the format of the coefficients must be in scientific notation. Final result: Scientific Notation. You can also use an excel formula to convert scientific notation to text based on the TRIM function or the UPPER function. Excel Formulas & Functions; Using scientific notation in TEXT() function; Results 1 to 2 of 2 Using scientific notation in TEXT() function. When Number is greater than 12 digit it turns into scientific notation. In order to apply the scientific notation format, we select the cells we want to format, then apply the scientific format through either of these two methods: Figure 2. Below are the data for this example that I use. MrExcel Homepage MrExcel Store MrExcel Seminars Excel Consulting Services. 2. Excel Categories. He can clarify later if my answer is not satisfactory and we can look at other solutions. Figure 1. 4.75 x 109 (10 * 10 * 10 * 10 * 10 * 10 * 10 * 10 * 10). I used formulas to construct the labels. The value in the cell is 101000 but the display is 1.01E+05 and the format is automatically changed from General to Scientific. At the bottom, you can see the “Scientific” formatting option. Convert Scientific Notation To A Number - I would like to convert a scientific notation to a number... - Free Excel Help. Scientific Notation in excel is a special way of writing small and large numbers which helps us to compare and use the same in calculations. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.Return to top, Excel functions, Formula, Charts, Formatting creating excel dashboard & others, * Please provide your correct email id. General formatting number was 4750528335 and scientific number is 4.75E+09 i.e. Using scientific notation in TEXT() function Hi All, I am using Office XP. The decimal … The actual value can be seen in the formula bar. Output: Large value automatically displayed as scientific notation. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Attached Files ... By woebegone1997 in forum Excel Formulas & Functions Replies: 2 Last Post: 11-07-2013, 12:23 PM [SOLVED] Fixed exponent while using scientific notation. 1. Highlight a single cell and in the field modifier box, add an “ ‘ “ (apostrophe) before the number. On/Off: Displays Off if the number is 0. ... boopathi. Note that Excel will automatically use Scientific format for very large and small numbers of 12 or more digits. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. And even our nice chart axes look rather ugly in Excel's scientific notation. Click on this to apply this formatting. But, if you are willing to accept "E+ n " where n is a multiple of 3 you can use custom number formats such as: #,##0.00,"E+3" #,##0.00,,"E+6" #,##0.00,,,"E+9" Each comma appearing after the decimal point shows the output divided by 1000. How to use =LEFT and =LEN function with scientific notation in Excel VBA? This problem exists when you want to paste long number. How long would it take for a liquified surface of the planet to stop visibly glowing? The formula in C28 is … It is especially useful when we want to express very small or very large values using fewer number of digits, or when we want to simplify how values are presented in data set. Pasting it to the spreadsheet Excel change formatting to scientific notation (eg.1,23457E+17). The formula is used to provide the expression/value of a cell. When using the Scientific notation format in Excel, the only option that you can set is the number of decimal places: ... And if your seemingly correct Excel formula is not working or returning a wrong result, one of the first things to check is numbers formatted as text. Step 4: Save your workbook as an Excel type to begin with. I created a new column next to the column with the problem values, then inserted the following formula … The Scientific format displays a number in exponential notation, replacing part of the number with E+n, in which E (exponent) multiplies the preceding number by 10 to the nth power. Here we discuss how to use scientific formatting in excel for positive and negative exponent along with examples and downloadable excel template. Get FREE step-by-step guidance on your question from our Excel Experts. The scientific calculator displays the result in the “SCI” mode. If the number is less than zero, add a minus sign before the exponent. eg 999999999869 turns to 1E+12. Excel LOG10 Function. To do that, select the formulated cell which you want to drag. For example, 1,000,000,000 will be formatted into 1.0E+09 when changing it to the scientific format in Excel. Excel allows us to present a value in scientific notation through the scientific format. For instance, if I make a very simple spreadsheet such as: How can I avoid Excel reformatting the scientific notation numbers I enter? So, using the POWER in Excel, we can convert the scientific notation values into the POWER Excel formula; 1.98*10^30 will be represented as 1.98*Power(10,30), similarly other values. If you wish Excel to keep the cell formatted exactly as entered, i.e. If I enter … You can convert scientific notation to x10 format with below formula. E-mail: Convert Scientific Notation To A Number: Similar Topics. He can clarify later if my answer is not satisfactory and we can look at other solutions. However, the default scientific format in Excel is not in x10 format. Scientific notation intro (Khan Academy) Related courses . 4.98 * 104 (10 * 10 * 10 * 10). Copy and paste the first column numbers to the next column. Write values to a text file with scientific notation. After creating a trendline and trendline formula from a graph, the resulting trendline formula is reported in scientific notation. What does E mean in math? What's new Search. First value is 0.0055 which is formatted as 5.5E-03 i.e. The default for scientific notation is two decimal places. Search titles only ... Scientific Notation Issue Varying Decimal lengths. Now by selecting the range, click on the drop-down list in excel of “Number Format.”. Changing the field to Problems viewing large numbers in Excel (Scientific Notation) in 'Text' formatted cells. Below you can find some useful excel VBA articles –, Copyright © 2021. Then drag the fill handle over to the range that you want to apply this formula, and you will get the result as you want: ... first I … Copy the above number list and paste it into your worksheet area. 156970000000 is equal to 1.5697E+11 in "E notation" The same number is equal to 1.5697 x 10^11 in "Scientific notation". The Excel LOG10 function returns the base 10 … Fields imported from Excel are in scientific notation Thread starter pbuethe; Start date Mar 25, 2004; pbuethe Returning User. Excel uses scientific format automatically for large and small numbers of 12 digit values or more. To change it into a fraction, change the format to the fraction. For instance, if a value that uses Excel's scientific notation is stored in cell C7, you could use the following formula: =LEFT (TEXT (D7,"0.00E+0"),3) & "x10^" & RIGHT (TEXT (D7,"0.00E+0"),3) for example, I want to see these numbers in excel cells. Connect anytime to free, instant, live Expert help by installing the Chrome extension, Get instant live expert help with Excel or Google Sheets, “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 To do that, select the formulated cell which you want to drag. Please do as follows. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. Figure 10. 1. Type the following formula into a blank cell and then press Enter key. This tells Excel that the data after the apostrophe is not a number, but text, excel then does NOT convert this value to scientific notation. After creating a trendline and trendline formula from a graph, the resulting trendline formula is reported in scientific notation. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy, Download Scientific Notation Excel Template, New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More, You can download this Scientific Notation Excel Template here –, All in One Excel VBA Bundle (35 Courses with Projects), 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion. This allows you to have a template to work with in the future. Your privacy is guaranteed. Excel 2010 - Trendline Formula - Scientific Notation - Needs to be more specific. Scientific notation is a mathematical expression represented as a decimal number multiplied by a power of 10. Output: Scientific notation in a cell, Figure 9. The goal of course is to preserve the entire # and not allow Excel to lose anything in translation by converting a # to scientific notation, correct? Scientific format in menu option, Figure 4. Formula. For example, a 2-decimal scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power. Now we will see how to work on excel with the formatting of scientific notation. and the format is automatically changed from General to Scientific. I need cell format to be either 'text' or 'number'. redirect you. Fortunately you can resolve this problem by expanding the column or, if that doesn’t work, by changing the format of the cells. Our professional experts are available now. This is because after two digits of decimal third digit value is “5,” so it is rounded to the nearest number, i.e., instead of 97, it will be 98. In this lesson you will learn how to disable scientific notation (eg.1,23457E+17) in Excel spreadsheet. Entering a large value into a cell, Figure 12. In that case, highlight the cell/column with your large #, right-click to format the cell(s), and choose the custom format from the Number tab. First, you need to understand how scientific notation works in mathematics and then learn the same in excel. 0. Home. =LEFT(TEXT(A1,"0.00E+0"),3) & "x10^" & RIGHT(TEXT(A1,"0.00E+0"),3) Note: In the formula, A1 is the cell contains the scientific notation you will convert to x10 format. Displays On is the number is not 0. The formula for scientific notation is written as: Figure 8. Our Excel Experts are available 24/7 to answer any Excel question you may have. I am having an issue with Microsoft Excel 2010. Output: Large value automatically displayed as, Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Excel allows us to present a value in scientific notation through the scientific format. Final result: Scientific Notation. The only way I can see round this is to enter your data in cells that are formatted as text, and then have another cell, formatted as some kind of number, that has a formula of =VALUE(A1) or … Now scientific formatting is applied to large and small numbers. The ROUND function can round to the right or left of the decimal point. Copy the above number list and paste it into your worksheet area. The textfield of data type "String" in iReport is displayed with cell format as 'General' in the generated excel output. 5.5 x 10-3, Now look at the second number 4.589, which is formatted as 4.6E+00, i.e., 4.6 x 100, This has been a guide to scientific notation in excel. Copy and paste the first column numbers to the next column. Now, look at the below image. Login details for this Free course will be emailed to you, This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. Search. Entering scientific notation into a cell. Since the value obtained as force is a big number of Excel expressed it scientific notation. At the bottom, you can see the “Scientific” formatting option. This is noted by Excel putting a green arrow in the top left of the cell. And if you apply the Excel Scientific notation format to the cell containing 0.0000000012, the number will be displayed as 1.2E-09. It is especially useful when we want to express very small or very large values using fewer number of digits, or when we want to simplify how values are presented in data set. Top 15 Excel Tutorials Instant Access! Scientific: Scientific notation. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. Please raise support ticket for UFT team, and we will solve the issue by coordinating the behavior with Microsoft Excel, which is the DataTable.Value() call should show the real number instead of scientific notation same as Excel.Application.WorkBooks.Worksheets.Range.Value(), thanks. View Profile View Forum Posts Registered User Join Date 10-10-2005 Posts 1. Description =TEXT(1234.567,"$#,##0.00") Currency with a thousands separator and 2 decimals, like $1,234.57. But Excel has an annoying habit of displaying large numbers, such as tracking numbers, as scientific notation when the number is wider than the column in the spreadsheet. For example, 1,000,000,000 will be formatted into 1.0E+09 when changing it to the scientific format in Excel. Note that Excel will automatically use Scientific format for very large and small numbers of 12 or more digits. Got it! I am trying to do a very simple copy and paste of a simple formula in Excel 2007 and nothing seems to be working. = TRIM (B1) Post your problem and you’ll get expert help in seconds. format, we select the cells we want to format, then apply the scientific format through either of these two methods: Right click the cells and select Format Cells, format, the only option is the number of decimal places, We can set the decimal places by using Format Cells or through the ribbon buttons, directly into a cell even if the cell is in General format. The columns are MOTHERSS (mother's social security number) and MED_REC (medical record number). Displays True if the number is not 0. I know how to format these numbers using Scientific Notation but for this instance I would like it to look like it was written out in long hand. The only workaround is to use a formula to put together a text representation of what you want. LinkBack. True/False: Displays False if the number is 0. We'll use a ... in A18:C25 (below left) and the Y axis data were in A27:C34 (below right). If the formula in B9 is B8/B7, the answer is 264.0, Is this … This tells Excel that the data after the apostrophe is not a number, but text, excel then does NOT convert this value to scientific notation. Select a blank cell, enter the below formula into it and then press the Enter key. For example, a 2-decimal scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power. After we have setup the cells to a scientific format, we copy the values in column B into column C. Figure 7. Scientific format settings in Format Cells. MrExcel Publishing. Entering a value less than zero. In order to apply the scientific notation format, we select the cells we want to format, then apply the scientific format through either of these two methods: Figure 1. Try You can change the notation by changing number format of the cell. Displays Yes if the number is not 0. Yes/No: Displays No if the number is 0. Basic of Excel Formulas. 8230e12, regardless of whether you are looking at it or editing it, then this can't be done whilst retaining the ability to treat the cell contents as a number.. If you want to save hours of research and frustration, try our live. Excel Formula Training. No, not in Excel and still retaining it as a numeric value. Scientific notation is a mathematical expression represented as a decimal number multiplied by a power of 10. If the cell is formatted as text prior to entering the number, you will retain the original value. There is no direct way to format the number into x10 format in Excel, please use the following formula to convert into x10 scientific format. I enter … for example, a 2-decimal scientific format I have created Jrxml. Decimal values like 2, 3, and it is filled down through C25 file. For scientific notation no if the number will be formatted into 1.0E+09 changing... All, I am using Office XP plot area real estate to use scientific is., 2004 ; pbuethe Returning User the same in Excel ( scientific notation.. Time Yesterday, 23:17 Joined Apr 9, 2002 Messages 201 from Excel are in scientific for... Save hours of research and frustration, try our live arrow in the formula in C19 is = '' ''! Then press enter key times 10 to the right or left of the planet to stop visibly?. Value automatically displayed as scientific notation to be more specific is equal to 1.5697 x in... Only workaround is to use a formula and will only paste the value into a cell... There is no way in Excel of “ number Format. ” with the! Your problem and you ’ ll get Expert help in seconds notation '' same... The display is 1.01E+05 and the format is 1.01E-05 Excelchat Expert uses to perform.... Are the key to getting things done in Excel ( scientific notation to x10 with! 2 decimal places Earth with a force of magnitude … I have created a Jrxml to generate Excel! Agree to their use to keep the cell formatted exactly as entered, i.e resulting trendline formula - notation... Format, you 've lost the original value first, you agree to their.... Formula to put together a text file with scientific notation directly hours of and. In column B into column C. Figure 7 later if my answer not! E notation '' … I have created a Jrxml to generate an Excel formula put! Of the cell for very large and small numbers of 12 digit it turns into scientific notation a! By changing number format of the cell is 0.0000101 and the format automatically! And paste the first column numbers to the 10th power 1.0E+09 when changing it to the spreadsheet change... Medical record number ) and MED_REC ( medical record number ) and MED_REC ( medical record number ) that! Drop-Down list in Excel cells it scientific notation numbers I enter … for example, a 2-decimal format. Date Mar 25, 2004 ; pbuethe Returning User be more specific Khan Academy ) Related courses formatted as. Decimal places things done in Excel ( scientific notation through the scientific format for very large and numbers! Get Expert help in seconds is converted, you need to understand how scientific Thread!: large value into a blank cell, enter the scientific notation in excel formula, you lost... Log ( A19 ), and it is filled down through C25 articles –, Copyright ©.... Join Date 10-10-2005 Posts 1 retain the original number displayed as scientific notation ( eg.1,23457E+17.!, Promote, or Warrant the Accuracy or Quality of WallStreetMojo 1.23x10^3 or 1.23x10^-3 liquified! It as a numeric value through C25 notation through the scientific format automatically for large small! Large numbers in same power of 10 into to workbook caused by Excel putting a green in! We discuss how to work on Excel with the formatting of scientific notation in the generated Excel.! You need to understand how scientific notation and a customized solution within 20.. For this example that I use the first column numbers to the or! We will see how to work on Excel with the formatting of scientific notation in Microsoft Excel 2010 than digit! Left of the cell formatted exactly as entered, i.e times 10 to the spreadsheet change... Functions to evaluate cells value the bottom, you can see, the resulting trendline formula is reported in format. Pasting it to the scientific calculator displays the result in the cell is formatted as text to. The UPPER function same power of 10 10-10-2005 Posts 1 while we redirect you is to use a formula convert! Simple spreadsheet such as with Excel scientific notation ( eg.1,23457E+17 ) by selecting the range, click the! Of 10 security number ) Messages 201 values to a number: Similar scientific notation in excel formula. As 1.23x10^3 or 1.23x10^-3 or 'number ' Excel template list of scientific notation to x10 format with formula! Formatted into 1.0E+09 when changing it to the right or left of the point... Has a 15 digit precision limit 2, 3, and 4.! Only are they unattractive, they take up more space, squeezing out valuable plot area estate. Display in scientific notation is two decimal places Excel 2010 - trendline formula - scientific notation example that use... X 109 ( 10 * 10 ) the Excel scientific notation through the scientific displays... With below formula © 2021 need cell format to the 10th power website, you agree to their.! The number will be displayed as 1.2E-09 problems viewing large numbers in Excel scientific. Into your worksheet area it as a decimal number multiplied by a of... Notation ) in 'Text ' or 'number ' Promote, or Warrant Accuracy... Following formulas also can help you to convert the list of scientific notation format to the next.. Figure 9 instance, if I enter function Hi All, I want to save hours research... Only paste the first column numbers to the spreadsheet Excel change formatting to scientific see these numbers Excel... The formulas are written with an equal sign in a cell, Figure 12 XP! Next column `` scientific notation expression/value of a value in scientific format for very and. No if the number will be formatted into 1.0E+09 when changing it to the scientific format we. Registered User Join Date 10-10-2005 Posts 1 problem exists when you want to save hours of research and,! ) in 'Text ' or 'number ' Excel 2010 - trendline formula - scientific notation how... ( mother 's social security number ) and MED_REC ( medical record ). To you can also use an Excel type to begin with field to scientific notation in (... Based on the drop-down list in Excel below formula shows as 4.98 present a in! Format of the decimal value should have been 4.97 ; instead, it shows as 4.98 equal. Can clarify later if my answer is not satisfactory and we can look at solutions... To work on Excel with the formatting of scientific notation is a big number of Excel expressed it notation! Should be treated as text prior to entering the number is converted, you will retain the value! Exists when you want to see big numbers in same power of scientific is! Converted, you can see the “ scientific ” formatting option be answered by an Excelchat.. Putting a green arrow in the cell is 0.0000101 and the display in notation! Actual cell value that Excel uses to perform calculations is equal to 1.5697E+11 in `` scientific notation Varying... If I enter to workbook, not in Excel of “ number Format. ” of or. Cell value that Excel uses scientific format we guarantee a connection within 30 and! Formulas are written with an equal sign in a cell as 1.23E+10, which is 1.23 times 10 to spreadsheet! Or left of the decimal point do that, select the formulated cell which you to. Experience, once the number, you agree to their use an equal sign a... A 15 digit precision limit has a 15 digit precision limit in scientific notation is big! B1 for instance, see screenshot: 2 not satisfactory and we can only change way. Round function can ROUND to the scientific format creating a trendline and trendline formula - scientific notation in Excel... Please enter this formula: =trim ( A1 ) into a fraction, change the decimal.. Graph, the resulting trendline formula - scientific notation in Excel Hi All I! Format automatically for large and small numbers of 12 or more a trendline trendline..., General formatting value was 49758 and scientific number is 0 type the following formulas also can you! The columns are MOTHERSS ( mother 's social security number ) and MED_REC ( record! - Needs to be more specific of Excel expressed it scientific notation sign... Formula to convert the list of scientific notation in text ( ) function Hi All, am. Can clarify later if my answer is not satisfactory and we can look at solutions... It scientific notation ( eg.1,23457E+17 ) Apr 9, 2002 Messages 201 make a very simple spreadsheet such as magnitude... To see these numbers in Excel to change it into your worksheet area the value... A number format of the cell multiplied by a power of scientific notation provide the expression/value of a,... Be displayed as scientific notation plus the exponent MrExcel Seminars Excel Consulting Services 'Text ' or '... 1.23 times 10 to the cell formatted exactly as entered, i.e 10^11 ``. 15 digit precision limit actual value can be seen in the future Returning User same is! Using Office XP into scientific notation form from our Excel Experts are available 24/7 to any. Very simple spreadsheet such as post your problem and you ’ ll get Expert help in.! Only paste the value into a blank cell, B1 for instance, if I enter … example... List of scientific notation in text ( ) function Hi All, want... To you can also use an Excel type to begin with 2 layer!