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!

Pokemon Soul Silver Storage

Changing the disk space reserved for System Restore in Windows Vista

As we saw in Windows XP was simple to change this size. He agreed to my computer, properties, were going to the System Restore tab. I chose one of the disc and we could change the size.

But since Windows Vista this option is modified and ah is not there anymore. Now must be done from the console. So here are some useful commands to solve this:

To see what is the maximum space allocated for shadow copies, follow these steps:

1) We click on and and let's start quick search.

2) Type cmd and select the program offered after completing the search with the right mouse button. Click on Run as administrator.

3) Provide administrative credentials or click Continue, as appropriate.

4) At the command prompt window, type the following and press Enter:

vssadmin shadowstorage

list Look at the output of the command line maximum storage space of the snapshot:. That the maximum space reserved.

If we are of those people we care the pc and do not need much space to restore the computer, so we want to reduce it must do the following:

In the same console abrimosanteriormente tipeamos:

vssadmin resize shadowstorage / on = C: / For = C: / MaxSize = 5GB

(replace C by the drive and also modify the value desired MaxSize )

Vssadmin return the following message: successfully changed the size of the shadow copy storage association.

Keep in mind that the drive where the system is installed where more has to be the space. In others, the less space there will be less the number of snapshots. It may not be running time, several days ago.