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

Set Image as Desktop Background Wallpaper with Google Chrome Extension

Set Image as Desktop Background Wallpaper with Google Chrome Extension

Several users might have come across fascinating, distinctive, strange, humorous, or uncommon digital pictures or graphics occasionally once they browse web. They might preserve these types of pictures and utilize them as desktop wallpaper. On the other hand, occasionally pictures turn out to be useless in their PC as the users forget to include all of them as wallpaper. If you want to reduce, the steps associated with transforming the images to wallpaper, also to shorten the procedure Google chrome users are able to check out this east extension “Set Image as Wallpaper”

“Set Image as Wallpaper” is a free extension of best casino bonuses Google Chrome presently working with windows only. With the help of installation of this extension in the web browser, users will be able to by-pass the process for saving the time, and directly right click the image. Users are able to select “Set Image as Wallpaper” within the pop-up shortcut menu to get the chosen image as wallpaper.  

Users are also provided with the option to alter the format, such as if they would like to stretch, centre, or tile to set the chosen image as wallpaper. This simple procedure will definitely make it possible for users to place interesting image as wallpaper and alter it with ease.

You can download it here.

Setting YouTube To Play High-Quality Videos By Default

Setting YouTube To Play High-Quality Videos By Default

YouTube has officially started delivering video clips in stereo audio mode and HD (High Definition) resolution for presenting a better viewing experience to the viewers. Now, viewers do not have to use &fmt=6 or &fmt=18 switch trick anymore to view high resolution videos on YouTube.

YouTube now has a link for users to view a supported video clip in high definition resolution. The link for watching high quality video appears beneath the video’s view count if high resolution display is supported.

If you are presently viewing the video clip in high definition, a link for viewing the video in standard quality will be displayed. This helps the user to easily toggle between standard quality and high quality video as sometimes streaming a video in higher definition might not go smoothly and the video might stop in between for buffering.

However, if you are a YouTube account holder, have a speedy internet connection and wish to watch all YouTube video clips in high definition mode always, you are now able to do so. YouTube has an option within the user account settings which allows you to set high quality as a default for video playback.

The video playback resolution by default is set as normal, which basically means lower quality. To make the changes in the video playback settings and set YouTube to play videos in high quality always (wherever available and supported), you need to follow the below mentioned steps:

  • Open the Account page on YouTube.
  • Under the section “Account”, click on the link “Video Playback Quality”.
  • Choose the radio button corresponding to the option which confirms that you have a fast internet connection and asks YouTube to play videos in high quality whenever available.
  • Click on the button “Save Setting”. This will make the changes effective immediately.
  • If you wish to revert back your selection, you can select the option for choosing the video quality dynamically depending on the connection speed. Alternatively, you may also choose the option for confirming that you have a slow internet connection and asking YouTube not to play videos in high quality.

Setting To Replace Lost Address Bar In Windows XP SP3 Using Muvenum

Setting To Replace Lost Address Bar In Windows XP SP3 Using Muvenum

If you are using Windows XP service pack 3, you may notice that the address bar of the Windows has been removed. The address bar can be started generally by going through Taskbar and then Toolbars. However it could also have been removed because of antitrust legal problem.

As a solution, you should get the substitute program. You can also obtain the add-in to put back or re-establish address bar into the task bar. The Address Bar named as MuvEnum is one of the substitutes.

MuvEnum Address Bar is undoubtedly the important substitute intended for replacing the lost address bar inside the Windows XP Service Pack3. This utility recreates the feel of the innovative address bar as well as provides lots of latest features for the browsers like Firefox 3.x, Internet Explorer.

There are lots of features for instance system-wide hotkey, where it lets you to open websites quickly, start programs, and navigate to favorites, internet searching and so on.

It has the ability to mix and display the bookmarks, favorites and histories from Internet Explorer or Google Chrome or Firefox 3.x.

It has additional features such as centering the address bar by means of a universal system-wide hotkey, and this unique address bar provides other features for System Locations, Environment Variables, Quick Search Aliases, Favorites, History as well as Inline Auto-Completion.

Downlod Muvenum

Settings To Add More Fonts For Command Prompt In Windows

Settings To Add More Fonts For Command Prompt In Windows

The appearance and style of Windows command prompt has always been the same ever since it had been launched for the first time up until now. Whereas Windows itself includes progressively influential features accessible. These features can be modified in a lot of ways in accordance to your preferences or your liking.

However, the command prompt still hangs about to be still the same along with extremely restricted customization and modifications. For example, you can select the fonts only between a couple of selections namely the Raster Fonts and Lucida Console. Also, you will not be able to add diverse fonts throughout the interface.

Well, you most likely you mightn’t know that that in reality you can insert extra fonts to command prompt by means of the very simple registry hack.

Prior to addition of extra fonts to the command prompt, following are some few principles that have to be satisfied:

  • The font should not be an italic font, or else will get the annoying A or C space
  • The font should be a fixed-pitch font
  • The font have to be OEM_CHARSET intended for font which is non TrueType
  • The font have to be FF_MODERN used for TrueType fonts

Go to Start Menu then Run, type “regedit” (without quotes) and hit enter.

Navigate to the following sub key:

HKLM\Software\Microsoft\WindowsNT\CurrentVersion\Console\TrueTypeFont

Go to the right widow; you will observe that the font added by default is Lucida Console furthermore below name file, named as 0. Therefore for extra fonts for the addition, you should name it like 00, 000, 0000 ….so on. If you do not follow these naming principles, the fonts that are added newly will not be shown.

Make a right click of mouse on TrueTypeFont, select New, go to String Value, put the value like 00 and then hit enter.

Enter the name of font below the Value data field by just double clicking on this recently formed String Value in above step. As the fonts which satisfy the criteria are Consolas, Courier New in ascending order, you’ll need to affix Consolas below name 00.

Go over above two steps to put in Courier New below name 000. Then, restart your computer.

After restarting the computer, open the command prompt and right click on top of the title bar, select properties. Under the tab named as Font, you will notice the fonts you have added recently. Pick one of the fonts. After that click OK button and save the whole setting.

Font Downloads

dafont

White Rabbit

Setting To Hide, Suppress Or Remove #DIV/0! Error In Microsoft Office Excel

Setting To Hide, Suppress Or Remove #DIV/0! Error In Microsoft Office Excel

In the Microsoft Office Excel spreadsheet program or Microsoft Excel, when you divide any value by zero (0) or else a blank cell inside the procedure, the cell will shows the answer which displays an error value #DIV/0!, as the answer of the computation.

The error value possibly will present weird feelings to readers particularly whilst the manual or worksheet is still in groundwork. It is also very awkward when you get the “#DIV/0!” mistake value when some formula is applied to several cells by copying and dragging.

This error value is takes place as it is incapable of dividing any value by 0. On the other hand, it’s likely to get rid of or take out the #DIV/0! Error value in the cell intended for unconfirmed or unacceptable dissection method with using IF worksheet utility.

To restrain or suppress #DIV/0 error value or for preventing the error from showing whenever it takes place. Apply the next formula on behalf of the normal division formula:

=IF(denominator=0,"",numerator/denominator)

The term “Numerator” stands for the number which is to be divided, and the “Denominator” stands for the divisor.

Such as, for rule of “A1/A2? (cell A1 divided by cell A2), the rule to go through into the answer cell is like given below:

=IF(A2=0,"",A1/A2)

The rule ensures to make out if the denominator is equal to zero (or is blank). Therefore, an empty unit is exhibited. If not, the unit that encloses the utility will exhibit the result of the rule term after the calculations.

Note:

In order to view other data in the unit if the divisor is empty or zero, enter the essential data in the rule everywhere, which is inside the quotation marks (“”). If you would like to show text, enter it in between these quotes. If you would like to show something else (values), you could enter the values in place of the quotes.

There is another IF worksheet formula which can be operated by using the “ISERROR” situation.

Following is the syntax designed for the formula bit is:

=IF(ISERROR(numerator/denominator),"",numerator/denominator)

Such as,

=IF(ISERROR(A1/A2),"",A1/A2)

Over here again, to exhibit extra information lying on the units, if the computation answer is wrong, then alter the value of the core limit (text string needs quotes).

After entering the mistake treatment method as per the instructions given above, you can drag in order to apply the rule to affect to other cells, and the created rule will automatically be applied to them as well.

Settings To Disable Caps Lock Key In Windows XP And Vista

Settings To Disable Caps Lock Key In Windows XP And Vista

You will not find any default function in your system to disable the Windows Caps Lock function. However, some of us want to disable it for whatsoever reason, for example you may have to disable it to avoid entering a cap-locked password or else to play tricks with your friends PC. All you have to is some changes and modifications in your Windows Registry.

You can follow in order to disable Caps Lock in your Windows XP or Vista OS.

  • Fist of all, copy and paste  following lines into your notepad

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout]
“Scancode Map”=hex:00,00,00,00,00,00,00,00,02,00,00,00,00,00,3a,00,00,00,00,00

  • Save the file as “nocapslock.reg“. You have to ensure that file name is nocapslock and file format is “.reg” not as nocapslock.reg.txt.
  • Now run the “nocapslock.reg” file by just double clicking on it. A confirmation massage will be prompted.
  • Just click on “Yes”
  • Restart your PC and you will notice that Caps Lock key is not functioning.

To restore back the Caps Lock key, just follow steps given below:

  • Open your Registry Editor. Then navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout
  • Remove the entire file named as “Scancode Map” or just delete the Scancode Map value.
  • As an alternate way to do this, copy and paste following lines into your notepad.
  • Run this file in the same way as you did before to disable caps lock key

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout]
“Scancode Map”=-

  • Finally restart your PC. Now your Caps Lock is enabled again.