How to format data in Excel?

It is important to have your data properly displayed, therefore, it today’s article, we will show you how to format data in Excel. Let’s assume the following table has been exported. What can (or should) be done?

1. How to separate a date and an hour?

First, you need to insert a new column, into which an hour will be inserted. Right-click on a column on the right-hand side and select “Insert”. Next, follow the steps showed in pictures.

Now, we should change the format of the date column in order to get rid of “00:00”.

2. How to separate the name of the street and the number?

You should follow the same steps as in separating the date and hour. The only difference is that you’ll have to select a comma as a separator instead of a space.

3. How to change the format of the postal code and phone number?

Both postal code and phone number are numbers. Unless you change their format now, you won’t be able to process the data later. Mark both columns and click on the exclamation mark which appears in the upper-left corner. Select “convert to number”.

4. How to change the way a phone number is displayed?

By default, phone number will have an xxxxxxxxx format, however, you might want to have it displayed in a different way, for example xxx xxx xxx. It is very easy to do that.

This is the final result:


Alberto Abad

CFO. Telecommunications engineer who loves accounting and taxation. He leads the development of the leading invoicing software that makes life easier for thousands of freelancers and SMEs.

Linkedin profile

Last articles

How to create a client information sheet

Every company owes its customers, so being in possession of as much customer information as possible by companies is a mandatory task if it wants to take advantage of one of the greatest competitive advantages a company can have is its own customer base.

How to attract more customers in 2020?

The best tips to increase your sales in digital media by Bernardo Salazar, guest author who gives us digital marketing tips to apply in your company. Generate active communication with your customers and attract more sales this 2020.

Distribute in Spain

We analyze the main characteristics of the distribution sector in the world, Europe and, mainly, for distribution in Spain. We tell you which items European and Spanish consumers have invested the most in. With the TOP ranking you know which companies are protagonists.

What is market research and how to conduct it?

In this article we explain how to do a step-by-step market research and how it will help you to grow your business.