How to Change the Data Format in Excel?

How to Change the Data Format in Excel?

Background

You were hired as a financial data analyst at a construction company. You were given a table and subsequent instructions on what to do with the data.The table is about vehicle purchase requests from the company’s branches. It includes all cash inflows that can be brought by those assets.

*All paragraphs underlined and in italics are the instructions from your boss. 

Action: Change the Data Format in Excel

First, your boss wants the raw data to be readable.

You can notice that the cash flows are hard to read because they don’t have any comma or dots that separate the numbers. This problem will be magnified if we are all ready to perform more calculations.

To solve this, we have to change the format of the cash flows into the Number format. Here’s how to do this:

Step 1: Select the values whose format is to be changed.

Raw Data

Raw Data Format

Step 2: At the center of the Home Tab, you should find a drop-down which lists different kinds of formats.

Different Data Formats

Different Data Formats

Step 3: You can choose either Number or Currency. If you choose a number, the data will change into a comma-dot format. If you choose Currency, the data will have a currency sign aside from changing into the comma-dot form. Assuming you have chosen a currency, it will look like this:

Currency Format

Currency Format

Step 4: If you want to change the currency, just click on the arrow like the one shown below:

Number Format

Number Format

Step 5: Under Number, choose Currency. You will be able to find a drop-down named Symbol. From there you can choose the currency you want.

Currency Options

Currency Options

What have you noticed? Don’t you think the data is hard to read because of the currency? The currency is not so important at all so let’s use the Number format.

Suggested: Read more about excel for finance

Step 6: Use the Number format so that it’s more readable. The data should now look like this:

After Number Format

After Number Format

Wrap Up

I hope this short guide helps you figure out how to change the data format in excel. If you learned something new today then do share this article who are struggling to find a solution to change the data format in excel. If you have any doubts leave a comment below and I'd be happy to answer your query.

How to Change the Data Format in Excel? 1
How to Change the Data Format in Excel? 2
Next Classroom Batches in India
- Classroom Course with Placement Assistance: Our Full-Time Financial Modeling Investment Banking Course (6 Weeks) starts on 16th September, 2019 and 2.5 Months Weekend Workshop starts on 27th September in New Delhi, India and on 13th September, 2019 in Gurgaon, India.

- Online Course with Placement Assistance: Join our Online Financial Modeling Investment Banking course with Placement Assistance from anywhere in the world.

- CFA Level - I: 16th November, 2019

- Big Data: 29th June, 2019

- Financial Modeling Investment Banking Weekend in Gurgaon: 27th September, 2019

- See Testimonials.

Only a few seats remain. Interested candidates can contact me.

Leave a Comment