Now when we return to your spreadsheet, you should see the number without any scientific formatting. When you are happy with how it will look, click on the OK button. When you are done setting up your number formatting, you can see in the Sample box what the number will look like. In this example, we've also set the number of Decimal places to 0 since our original number did not display any decimal places.
When the Format Cells window appears, select the Number tab and highlight Number under the Category. Right-click and then select "Format Cells" from the popup menu. To remove scientific formatting from a number in Excel, select the cells that you wish to remove the scientific formatting. How can I get the original value to display properly without scientific format?Īnswer: You can change the appearance of numbers in Excel by applying formatting. Question: In Microsoft Excel 2003/XP/2000/97, I'm trying to enter the number 123456789123456000 but it is converts the number into scientific format and displays 1.23457E+17. If you are having trouble getting your spreadsheet to print properly, then check out this guide about some common print setting adjustments you can make.MS Excel 2003: Display a large number without scientific format Step 4: Click the type of formatting that you would prefer to use on these cells (some common ones include General, Number, or Currency), then click the OK button at the bottom of the window. If you are unable to right-click, then you can click the Home tab at the top of the window, then the Format button in the Cells section of the ribbon, followed by the Format Cells option. Step 3: Right-click one of the selected cells, then click the Format Cells option. This article explains more about selecting the entire spreadsheet. Note that you can select an entire row by clicking the row number at the left side of the spreadsheet, an entire column by clicking the column letter at the top of the spreadsheet, or you can select the entire spreadsheet by clicking the button at the top-left corner of the spreadsheet. Step 2: Highlight the cell(s) that are adding a percentage symbol behind numbers that you enter. Click on the dropdown list next to Symbol and select. Under the Category list, select the ‘Currency’ option. This will open the Format Cells dialog box. Right-click on your selection and click Format Cells from the popup menu.
Step 1: Open your spreadsheet in Excel 2010. Select the cells containing the dollar signs that you want to remove. We will be switching from Percentage formatting to General formatting in the steps below, but you can also choose a different type of formatting, such as Number or Currency, depending upon your needs. This tutorial assumes that you have a cell, or cells, that automatically adds a percentage symbol behind a number after you type it in. These steps are very similar for other versions of Excel, but may vary slightly. The steps in this article were written using Microsoft Excel 2010.
How to Switch from Percentage Formatting in Excel 2010 Our tutorial below will show you how to select and modify cells that currently include percentage formatting. So if you find that a percentage symbol is being added automatically when you enter a number into certain cells, then you might be looking for a way to stop that behavior.įortunately this is a formatting option that can be switched in Microsoft Excel 2010 with only a few steps, and you can choose from one of many other formatting options based upon your needs for the situation. If you are working on a spreadsheet that was created or edited by someone else, then it is very possible that they have added their own formatting to it. Cells in an Excel spreadsheet can contain many different kinds of data, and they can be formatted in many different ways.