I have received some data from an external source. The current format of the data is shown as dd-mmm-yy, however, when you highlight a cell , in the formula bar - it shows dd/mm/yyyy (i.e. includes the century!).
The problem is the centuries are wrong for some cells of data. I want a separate column to copy the data - and only store dd/mm/yy - whereby yy represents only the last 2 year, i.e. for 2014 it should only store 14. I only want this data and I presume it would be better as text as opposed general/dates which may actually store the century information.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.