Office Solutions

2 Useful Methods to Convert Numbers to Dates in Your Excel Worksheet

The numbers in cells will not turn into dates automatically in a certain condition. Therefore, in this article, we will provide two methods to help you solve this problem. You will certainly need to input dates into excel worksheet. And there are many different types of date format. On the other hand, you will also copy some dates into Excel cells. However, if there is no symbol for dates, i.e. the hyphen symbol (-) or the slash symbol (/), those numbers will not change into dates...

Read more »

How to Connect Different Files by Inserting Objects into Your Excel Worksheet

Most of the work will relate to many different types of files. In this article, we will show you how to insert objects into your Excel worksheet to connect files. When you are working on a task, you will certainly use many different types of files. For example, you will use Excel to analyze data and information. And you will use the PowerPoint to demonstrate some research results. Besides, there are many other types of files. Actually you can connect Excel files with other types of files by...

Read more »

How to Create a Drop-down List in Outlook Contact Form

Outlook supports you to design forms, no matter the message, task, appointment or contact form. Have you ever wanted to create a drop-down list in the default forms? This article will take Contact form as an example and teach you to create a custom drop-down list. When I create new contact, I tend to input the relationship with this contact, such as colleague, superior, friend, relative and others. In the past, I just created a new custom field called as “Relationship”, like the...

Read more »