Excel Basics

Why Is Excel Changing My Numbers: 4 Methods

Method 1 - Enabling Auto-Insert Decimal Point Option is Changing the Numbers in Excel Make a marks list of a subject for the student. In ...

How to Stop Excel from Changing Numbers to Scientific Notation (7 Methods)

Dataset Overview Looking at the Sales Data in cells B4:D14, where we have the Customer Name, Invoice Number, and Sales in USD. The Invoice Number, ...

How to Edit AutoComplete in Excel (4 Easy Methods)

Excel has some auto features that save a lot of time and give more speed while we are typing or inputting data. AutoComplete is one of them and we ...

[Fixed!] Excel Changing Dates to Random Numbers (3 Solutions)

Sometimes, when we input dates or do some operation with the dates, they change into random numbers. As a result, we cannot see the original dates. ...

How to Stop Excel from Auto Formatting Numbers (3 Easy Ways)

As can be observed in the animation below, by default Excel changes the format of numbers after they've been input. It can become tiresome having to ...

How to Stop Autocorrect in Excel for Dates (3 Quick Ways)

Excel has extraordinary autocorrect features. When you type some data in Excel cells, it auto-corrects the data type sometimes which might create ...

[Solved!] Long Numbers Are Displayed Incorrectly in Excel

Working with long numbers (more than 11 digits) can be a problem in Excel. There are some auto formatting options in the program to keep the ...

How to Stop Excel from Rounding 16 Digit Numbers (2 Easy Ways)

The Reasons Behind Excel Rounding Numbers Excel maintains IEEE 754 in storing numbers. Numbers containing digits up to 15 will be displayed as ...

Why is Excel Changing My Numbers to Decimals? (2 Solutions)

Consider the following dataset where students' marks are entered in column C. While entering 62 in cell C5, it unexpectedly becomes 0.62. We have ...

How to Turn Off Spell Check in Excel (with Easy Steps)

Excel or other Microsoft Office applications has some intelligent features. Spell Check is one of them. While writing in an Excel sheet, you can make ...

How to Color Code Cells in Excel (3 Methods)

We'll use a sample dataset of students and their grades to color code cells. Why Is Color Coding Cells in Excel Important? Visual ...

How to Flip Table in Excel (2 Quick Ways)

Although Excel offers no direct ways to do so, in this article we will demonstrate how to flip data by columns and rows using Excel’s built-in ...

How to Insert the Current Date and Time in Cell A1 (6 Easy Ways)

Need to learn how to insert the current date and time in cell A1? Sometimes we want to enter the latest time when an employee arrives at his ...

How To Select All Rows to Below in Excel (3 Easy Methods)

While using an Excel dataset we may need to select an entire row below a specific cell. Sometimes we may need to select some of the columns in a row. ...

How to Unhide a Sheet Tab in Excel (7 Methods)

Method 1 - Using View Tab Suppose you have a workbook where the sheet tabs are accidentally hidden. To restore them, follow these steps: Go ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo