Convert number of month to name of month in Excel

1 comments
Lets assume Date in A1 cell then use the follwing formulas
  • =TEXT(A1,”MMMMM”)
    for the first letter of the month
  • =TEXT(A1,”MMMM”)
    for the month spelled out completely
  • =TEXT(A1,”MMM”)
    for the 3 letter abbreviation of month
Continue Reading...

How to Copy and Paste values without Formulas in Excel?

2 comments
In Microsoft Excel, when you perform a normal copy and paste on a cell that has been calculated by a formula, the formula gets pasted as well. Sometimes, when you copy the contents of a cell, you want to paste just the value and not the underlying formula that is displayed in the formula bar like copy the resulting value of a formula to a cell on another worksheet. You can get an invalid cell reference error (#REF!) error.

You can avoid this error by pasting the resulting values of formulas without the formula in destination cells.

  1. Select the cells or ranges you wish to copy.
  2. On the Home tab, under Clipboard, select Copy.
  3. Select the cell you wish to paste your values to.
  4. Click the lower half of the large Paste button; from the extended menu that appears, select Values. Then click OK.

Or use a Shortcut Menu

  1. An even quicker way to paste values is by using a mouse shortcut:
  2. Point to the border of the selected range, and the pointer should change to a four-headed arrow.
  3. Press the right mouse button, and drag the cells slightly to the right.
  4. Keep pressing the right mouse button, and drag the cells back to their original location.
  5. Release the right mouse button and a shortcut menu will appear.
  6. Click on Copy Here as Values Only.
  7. The formulas are replaced by the values of their results.
Continue Reading...

How to skip Windows 7 login screen?

3 comments
If you have been running Windows 7 on your personal computer, chances are high that you haven’t assigned a password for your user account. Whenever you start your computer / laptop, the boot process will stop at the Login screen and you need to hit enter or click on your user account picture to see the desktop.

As you need to hit enter each time you start your your computer / laptop, here is quick solution to skip the Login screen.
  1. Click on Start and then enter the following command in the search box, then "netplwiz" and press the ENTER key. Or Open Run dialog box by using Windows + R keyboard shortcut and type "control userpasswords2" in Run dialog box and hit enter. This command will load the Advanced User Accounts Control Panel applet.
  2. Under User Accounts tab, uncheck the box named Users must enter a user name and password to use this computer.
  3. Click Apply button to see Automatically Log On dialog box. If you have a password for your user account, simply enter the password and click ok. If you don’t have a password for your account, simply click Ok.
  4. You are done. Reboot your Windows 7 to see the change.
Continue Reading...

How to calculate person's age in Excel

9 comments
There are many ways to calculate a person's age in Excel.

To calculate the age of a person on date since their birthdate:
=INT((date-birthdate)/365.25)
To figure their age as of today, date can be replaced with a function like TODAY() or NOW(). The INT() function is used to return only the number of complete years.

Let's say suppose Cell A1 contains "13-11-1984", then you can find person's age by enterring the following formula as
=INT((A1-birthdate)/365.25)

To calculate age in terms of years, months, and days, DATEDIF is a handy function. The following formula is similar to the one above.
=DATEDIF(A1,TODAY(),"Y") & " years, " & DATEDIF(A1,TODAY(),"YM") & " months, " & DATEDIF(A1,TODAY(),"MD") & " days"
Continue Reading...
Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger