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 Cloud Connect Free – How To Install / Integrate Cloud Connect With Microsoft Office Suite

Download Cloud Connect Free – How To Install / Integrate Cloud Connect With Microsoft Office Suite

Cloud Connect – a plugin, Google is planning to release shortly, will integrate Microsoft Office Suite with Google Docs. The word ‘Cloud’ in the name signifies that it has something to do with ‘Cloud Computing‘.

If you always wished that what ever changes you made in a word document that you were editing be saved elsewhere, preferably online, you’ve got it now! Cloud Connect, automatically syncs what ever changes you make in your Microsoft Word document, to your Google Docs account, when you hit the ‘Save’ button. Ofcourse, here we assume that you have internet connection which is working fine, and you are connected to the internet and most important of all, you are using the ‘Cloud Connect‘ Plugin.

Some of the advantages are you don’t have upload the data every time you save it, for sharing the same with others. The moment you save the doc, the data is available for others to view it. Cloud Connect currently supports Excel and Powerpoint apart from Microsoft Word. Multiple people can work on the document at the same time (user conflict might creep in here, under such circumstance Google puts an alert prompt asking you to choose the version you wish to keep). You have options to switch back and forth, based on versioning history.

Microsoft has similar plans, online integration. Drawback with Microsoft’s Online integration tool is that users have SharePoint in between, also seems like Microsoft has some work that needs to be done in Excel front.

As of now, it is available for all the Apps Business customers. Commoners will still have to wait to get hold of this plugin. If you wish to volunteer, you can get on their list and Google will notify when opportunity is available (volunteer form link).

Disable History List Of Recent Documents In Office 2007 Word, PowerPoint And Excel Applications

Most of us find it handy to have an extended Recent Documents history record in Office Excel, PowerPoint and Word 2007 as it offers a smart shortcut to check recently used spreadsheets, presentations and files. But sometimes Recent Documents history record can be a big problem for users who work with private or sensitive documents.

History list showing “Recent Documents” tends to expose the existence and trace of documents which are otherwise hidden. Users who do not wish to use the expanded Recent Documents aspect in Office 2007 can follow a simple method to disable history tracking on used files.

To ensure that MS Office 2007 applications do not keep a track of recently opened documents history or MRU list, you need to follow some easy steps mentioned below:

1. First of all, click on the office button on any of the MS Office 2007 applications. If you open Word Doc, then click on the “Word Options” tab, if you open Excel, then click on “Excel Options” tab, or if you open a PowerPoint file, click on “PowerPoint Options” tab.
2. Then choose the Advanced tab
3. Scroll down to view the display section
4. Now fix the count for “Show this number of Recent Documents” as 0 (Zero).
5. Click on the “OK” button
6. You will need to repeat the steps for all Office 2007 applications, which are PowerPoint, excel and Word.

By doing this you will notice that your “Recent Documents” list appears blank all the time.

Setting a registry value is possible to facilitate a policy that avoids display of MRU lists. Users need to take a note that this policy affects a majority of Microsoft programs including all Office versions along with its individual products.

Hence, by using registry value trick to turn off the policy, you can prevent display of most recently used documents history for all programs such as MRUs on open and save dialog boxes and the file menu.

1. You need to use “Run” from Start button and type “regedit
2. Then follow the path HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer

If you are unable to locate “Explorer”, you will need to create the entry in policies folder.

3. With the help of “NoRecentDocsHistory” key, create DWORD value and fix the value as 1

The “Recent Documents” record history will stop getting listed henceforth and you will find it blank at all times.