How to Change the Data Format in Excel?


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.

Next Batch Starts on 29th April, 2019
- Classroom Course with Placement Assistance: Our Full-Time Financial Modeling Investment Banking Course (6 Weeks) starts on 29th April, 2019 and 2.5 Months Weekend Workshop starts on 6th April, 2019 in New Delhi, India and on 16th March, 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 April, 2019

- Financial Modeling Investment Banking Weekend in Gurgaon: 6th April, 2019

- See Testimonials.

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

View All BIWS Courses –Free $397 Bonus for FinanceWalk Readers

Leave a Comment

Want to Create a Lucrative Career in Investment Banking?