Finding Walkie Talkie Channels

Automatic logon in Windows XP/Vista/7

We hate to have to type the password every time you turn the session. Well here I spent a little trick to start automatically.

Let's Start, Run, and type (usually in windows vista or seven do not see the run button, just in the form put "Run")

control userpasswords2

We choose the user account we want to use and uncheck the option "Users must enter a user name and password to use the computer."

Here we ask you for username and password ready. We to accept ... From now you are automatically logged.

Become Third Party Payment Processoe

Convert string to date in Excel

Microsoft Excel - All Versions

often is taken to be working with various information systems that export the information from the system to Excel to produce reports is that the dates do not come in a readable format for Excel, causing a headache for us fraud. Here I will share with you a simple formula to convert the following types of text strings to dates:

• dd-mm-yyyy dd.mm.yyyy

For this we use the following formula:

= DATEVALUE (CONCATENATE (MID (cell, 1, 2 );"/"; MID (cell, 4, 2 );"/"; MID (Cell, 7, 4))) Where

cell represents the cell where is the string to convert.
Finally we set the format of the cell as a date.

To convert the following types of strings:

• dd-mm-yy
• dd.mm.yy

In this case we use the following formula:

= DATEVALUE (CONCATENATE (MID (cell, 1 , 2 );"/"; MID (cell, 4, 2 );"/"; MID (Cell, 7, 2))) Where

cell represents the cell where is the string to convert.

Finally we set the format of the cell as a date.

And the last case is for dates in the following format: ddmmyyyy

That use case:

= DATEVALUE (CONCATENATE (MID (cell, 1, 2 );"/"; MID (cell, 3, 2 );"/"; MID (Cell, 5, 4))) Where cell

represents the cell where is the string to convert.

Finally we set the format of the cell as a date.

How To Do Fishbone Weaving

Disable Autoplay CD / DVD and Flash Drive in Windows XP

you tired of many viruses will infect the machine for connecting a flash drive in your computer. Sos of working at school or work and bring information on the stick and you infect the machine.

Most of these viruses are installed on a conocodi file as "autorun.inf" that Windows is used to run when you connect a device. Therefore we recommend disable this option in the following mantero:

First we click on Start and going to run. After tipeamos gpedit.msc. In the window that must be opened in the left bar to

Computer Configuration / Administrative Templates / System and then look Disable the autoplay option.

doing so will get a window that let us choose from several options. We click on Enabled and "Off reproduction automaticab in: " choose the option in all the devices.

Once this is done, not wait for restart must run the following command: Gpupdate

And Ready! With that disable automatic reproductions!