Tips for Changing and Displaying Month Number as Name Text in Excel

Tips for Changing and Displaying Month Number as Name Text in Excel

Microsoft Excel has numerous functions that allows adjustment involving date and time, one of which will be MONTH (), which usually returns 12 months of a year with variety which range from 1 (for the month of January) to 12 (December). Several ‘Microsoft office‘ Excel users might prefer the month to be shown or perhaps shown as month name within text as an alternative to number, in the form of Jan, February, March and so forth, or just Jan, February, Mar along with and so on, instead of 1, A couple of, 3…

If you want to turn the number to month inside text message file format to show the name of month, make use of the subsequent operate inside the cell, which the name of the month will be displayed.

=TEXT(DATE(2010, A1, 1), “mmmm”)

Here, 2010 is a model year, the cell number A1 is where you’ll find the number of month and the day is by default 1.

In the event the cell contain a month rather (and never the month number), it is possible to use the particular MONTH () function in order to obtain month number. The particular dummy year and day can be substituted for YEAR () and DAY () functions to provide year as well as day number of the date, that could be helpful for adjustment later. For example

=TEXT(DATE(YEAR(A1), MONTH(A1), DAY(A1)), “mmmm”)

The text format of TEXT() task could be delineated to return the month name (and even year, day or date) in prefer format. Use the following format_text (to replace “mmmm”) for showing different name of the month in text:

“mmmmm” = Here it displays first alphabet of the month          

“mmmm” = Month is spelled out completely

“mmm” = 3 letter short form of the months like Jan, Feb, Mar and so on

“yy” = Last two digits of year without century

“yyyy” = four digits format of the year

“d” = distinct number screening 1st – 9th day of the calendar

“dd” = 2 numbered day displaying with 1st – 9th day of the calendar supplemented with 0 as a prefix

Download Latest Installer To Keep Your Installed Applications Up To Date

Download Latest Installer To Keep Your Installed Applications Up To Date

It is not an easy job to keep all installed software applications up to date for all time. For enjoying the new features in the applications, you will need to check for the updates on the respective websites. This could be pretty time consuming and exhausting activity as you should go to each website and then check for the updates for respective applications.

Using a small application named as Ketarin, you will be able to addresses this concern. It helps you to monitor the applications and also you can verify whether the installed software application is latest or not. When there is need to download the latest version of any software, Ketarin will automatically download the latest installers to keep your software applications up to date.

Ketarin is quite similar to Radarsync, which scans all the drivers including all the software applications installed in PC. Radarsync is able to create an efficient installer’s links list. On the other hand, Ketarin works in a slightly different way. Ketarin is able to find out the available latest version for your installed software applications. The installer is then automatically downloaded to the path which is specified by you.

You will not be forced to install the newest version of application and you can decide whether to install it now or later. Ketarin, by default, utilizes FileHippo for obtaining the updated installers. In case, an update installer for your most preferred software is not obtainable by this website, you can go for another URL.

When the download process of installer completes, you can define or write the commands to run, for example virus scans, unzipping the zip package, background installation and so on. This software is an open source free application. A language C# for .Net Framework 2.0 is used to design it. SQLite is used as a database engine.

Search Emails Received Or Sent On A Particular Date

Search Emails Received Or Sent On A Particular Date

The current options of searching for emails in Gmail don’t allow users to search emails or messages received within a particular range of dates. The user can only search messages depending on the range of dates listed in a drop box. The range is shown as 3 days, 2 weeks, 2 months, 12 months and others.

If the user needs to retrieve or access messages received within a specified range of date, then he/she needs to follow the steps mentioned below:

1.  Login to your Gmail account.

2.  Go to the text box indicating Search Mail situated at the top corner of the webpage.

3.  The users can filter messages according to recipient, subject, sender and a specific range of date.

The following syntax is to be followed in order to get desired results

from:xxx@abc.com to:yyy@xyz.com subject: greeting after: YYYY/MM/DD before: YYYY/MM/DD

The From: keyword is used to indicate the senders email address, to: is used to indicate the recipients email address, subject: field is for the subject which the user is looking for, the before: and after: field depicts the range of the date within which you are searching the message from.

A simple example is

From: mala@yahoo.com after: 2010/07/02 before: 2010/05/01

This gives the messages received from the above said email id and within a period of 2010/07/02 and 2010/05/01.

The above mentioned steps are extremely simple and will surely help you achieve greater precision with respect to the results searched for.