Tachytelic.net

How To

Convert US Dates to UK Format in Excel

by 1 Comment

If you have a column of dates in Excel that are in US format, it is easy to convert them to UK format. Simply follow these steps:

  1. Select the column containing the US Dates:
    Image showing selection of column of US format dates in Excel
  2. From the Data Ribbon, Choose “Text to Columns”:
    Image showing the data Ribbon on Excel with the Text to Columns function highlited
  3. Choose “Delimited” from the Text to Columns Wizard, then click next.
  4. Untick all the delimiters.
  5. In the column data format area, choose “Date” and select “MYD” from the drop down menu:
    Image showing Excel Text to Columns Column data format. To convert US dates to UK dates
  6. Excel will now recognise the column as dates and you use format cells to select the UK date format, or any format that suits you.

How is a video demonstration of how to convert US Dates to UK Format:

 

How to create a Network Connections Shortcut in Windows 10

by Leave a Comment

  1. Press Windows Key + X
  2. Press “W” or left click on “Network Connections”
  3. Click on “Change adapter options”
    Image Showing the "Change Adapter Options" button in the Windows 10 Network Status folder.
  4. Drag the Network Connections Icon in the Address bar to your desktop:
    Image showing how to create a shortcut on Windows 10 Directly to the Network Connections Folder

Access Network Connections Folder from the Run Dialog

Another quick route to the network connections folder:

  1. Press Windows Key + R
  2. Type ncpa.cpl
    Image showing how to access the network connections folder quickly using ncpa.cpl

Quick access to the classic Network Connections folder is really useful if you want to:

  • Disable an adapter.
  • Change your IP Address or default gateway.
  • Modify your DNS settings.
  • Change the metric of an Interface.

 

 

How to reset the root password on SCO Openserver 5

by Leave a Comment

Should you need to reset the root password on a SCO Openserver 5 system, the procedure is quite simple, do the following:

  1. Boot from your Emergency Boot Disk.
  2. Type the following commands: 
    mount /dev/hd0root /mnt
/mnt/bin/chroot /mnt /bin/su root
passwd
  3. You should then get the change password prompt:
    Image showing how to reset the root password using an Emergency Boot floppy
  4. Then reboot the system with:
    sync;sync;sync;reboot
  5. Login with your new root password.

Here is a video of the procedure:

This example was done with SCO Openserver 5.0.7 – I used a virtual 2.88Mb floppy with both boot and root file-system support.

If you need help or support with your SCO system click here.

Disable Simplified Account Creation in Outlook 2016 or 2019

by 6 Comments

Recent builds of Outlook have a simplified account creation wizard. Here is how to disable it:

  1. Close Outlook if it is already open.
  2. Next, Open registry editor (Windows Key +R, Type in regedit and click OK.
  3. In registry editor navigate to and select:
    HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\Setup
  4. From the Edit menu, click new, then DWORD (32-bit) Value:
    Image showing creation of new registry entry to disable simplified account creation in Outlook 2016 or 2019
  5. Name the new DWORD:
    DisableOffice365SimplifiedAccountCreation
  6. Double click on the new DisableOffice365SimplifiedAccountCreation entry.
  7. In the Value Data box type 1, then click OK:
    Image showing the DisableOffice365SimplifiedAccountCreation registry entry being set to 1, which will disabled the simplified account creation wizard.
  8. Close registry editor and restart Outlook.

If you prefer, simply download DisableSimplifiedAccountCreation.reg here and the correct registry entry will be imported.

Image of Windows Registry Icon
To download, right click and then choose save as.

 

How to clear RDP Connection History

by Leave a Comment

For every successful connection, the RDP client stores the connection details for the machine that you have connected to. This is often convenient, but if you are on a public machine, it can expose sensitive security details. The RDP client does not give any way to clear the cached connection history.

Image of Remote Desktop Client showing connection history

You can clear the RDP Cache history in a couple of ways:

Clear the RDP Cache from the registry using regedit

  1. Open regedit.exe and navigate to:
    HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client
  2. There are two registry keys here that need to be cleared:
    • Default – Has the history of the last 10 RDP Connections.
    • Servers – Contains a list of all the Remote Desktop connections that have ever been established from this machine.
  3. Expand the Default Key which will contain the most recently used connections. You can delete every entry or select which ones you want to remove:
  4. Select the entries that you want to remove, right click and click delete:

    Image showing history of RDP connections in the Windows Registry
    Hold shift to select a range, or CTRL to select multiple entries at once.
  5. Now expand the Servers key, this contains the details of all the RDP connections that have ever been made from this machine, including the username used to connect:
    Image showing connection history of RDP client in Windows Registry
  6. There may be many entries, it is easier to delete the entire servers key, then recreate it.
  7. Finally, delete the default.rdp file found in your homepath. This is a hidden file and will not show or delete by default. You have to supply an extra switch to the delete command:

    Image showing correct command line to delete default.rdp from users home directory
    Use command: del /ah %homepath%\documents\default.rdp

Clear the RDP Cache using a batch file or command line

A far quicker way to clear the RDP cache is to use the following commands:

reg delete "HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default" /va /f
reg delete "HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Servers" /f
reg add "HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Servers"
del /ah %homepath%\documents\default.rdp