How to Stop MS Excel from Rounding off Numbers

When you type in a large decimal number, MS Excel will likely round off the number. This can be due to several reasons: 

  • The column width is too small
  • The format is set to General instead of Number
  • The number of decimal places to be displayed is set for a lower number.

As a result, it can be annoying when Excel automatically rounds off your numbers. However, you can easily rectify this by using any of the methods given below.

5 Methods to stop Microsoft Excel from rounding numbers:

  • Increase the column width
  • Increase the decimals
  • Format the cells
  • Add an apostrophe
  • Format the number as text

Let us begin by looking at all the methods in detail.


Read more

How to Round off Decimals in MS Excel

Rounding off decimals helps to improve the readability of your information. It is also simpler to work with numbers where the decimals have been rounded off. It is also very helpful when exact values are not required.

4 Methods to round off decimals in Microsoft Excel:

  • The ROUND function
  • The ROUNDUP function
  • The ROUNDDOWN function
  • The MROUND function

Let us begin by looking at each of these methods.

Read more

How to Convert CSV to MS Excel

A CSV file is a very basic file that stores data in a simple format, separated by commas. That is why it is called CSV – comma-separated values.

In contrast, MS Excel saves data in spreadsheets with formatting and formulas. It is best to convert a CSV file into Excel to make use of the information.

2 Methods to convert a CSV file to Microsoft Excel:

  • Save As option
  • Data Import option

Let us begin.

Read more

How to Combine MS Word Documents

Combining the contents of Microsoft Word documents should be easy. Simply copy and paste one document into the other. This method works well, provided the documents are small.

The copy and paste method becomes tedious when the documents are large. It is even more tedious when merging several large documents.

MS Word makes it easier to combine many documents with a simple method. We will show you this method with easy, step-by-step instructions.

Let us begin.

Read more

How to Create a Fishbone Diagram in MS Word

A fishbone diagram depicts the cause-and-effect relationship of a situation or problem. It is typically presented in a pictorial format. That makes it easier to understand the root cause for taking remedial steps.

It is possible to create a fishbone diagram in Microsoft Word using various shapes. Unfortunately, there is no built-in template in Word to create fishbone diagrams.

We will show you simple, step-by-step instructions for creating a fishbone diagram in MS Word.

Let us begin.

Read more

How to Add Days to a Date in MS Excel

Adding days to a date helps determine deadlines. It can simplify various tasks at hand. For example, completing a task 10 days after the previous task. It is also ‌helpful in stock management, to make sure you don’t sit with old stock. 

4 Methods to add days to a date in Microsoft Excel:

  • Use formula A when the number of days to be added is the same
  • Use formula  B when the number of days to be added differs
  • Use the Paste Special option
  • Use the End of Month formula

Let us begin.

Read more

How to Get the Number of Months Between Two Dates in MS Excel

You may need to get the number of months between two dates for several reasons. If you are assigned a new project, you may need to know how many months you have to finish it. This Excel trick essentially helps you know the span of any event. There are several ways to get the number of months between two dates in MS Excel.

5 Methods of getting the number of months between two dates:

  • Use the YEAR and MONTH function
  • Use the MONTH function and subtract the dates
  • Use the DATEDIF function
  • Use the YEARFRAC and ROUNDUP function
  • Use Microsoft VBA code

Let us begin by getting a closer look at these methods.

Read more

How to Add Months to a Date in MS Excel

Adding months to dates could be very useful.

For example, you have the manufacturing date of multiple products with the number of months they are viable.

You can calculate the expiry date of the product by adding the number of months from the manufacturing date.

This can be done quickly, using MS Excel.

4 Methods to add months to a date using Microsoft Excel:

  • Use the EDATE function
  • Use the MONTH function
  • Use Microsoft VBA code
  • Use the Fill Series option

Let us begin by looking at each of these methods in detail.


Read more

How to Add Years to a Date in MS Excel

For calculation and data analysis, you may need to add years to a date in MS Excel. For example, to calculate the date of expiration of goods, to analyze the sales of a company after a period of time or to determine your policy’s payout date.

To do this, MS Excel provides several formulas to make this task easy to execute.

3 Methods to add years to a date in Microsoft Excel:

  • Use the YEAR & DATE function
  • Use the EDATE function
  • Use a generic formula

Let us begin.


Read more