Wanted to translate two-digit years into 4 digit years for the 1900s only.

Two digits were getting written as 35-37 or 40-50 in the spreadsheet.  This needed to be translated to 1935 1936 1937 or 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950.


By creating a file named ‘years’ with two-digit years on each line.

67 80

55 60

45 50


Wanted to have Excel do this automatically.  But for now, I’m just using this method and copy/pasting results into the spreadsheet.   If anyone has any suggestions, please let me know.


Create a new directory.

(any directory name will work)

Copy your new fonts into that directory, they should have the extension *.ttf

To make all these new fonts updated to the system run.

That’s it.

So I never realized this before but certain IP addresses will get truncated in Redhat/CentOS distro’s.  Not sure if others distro’s will share this feature but something to pay attention to.  They say that the netstat output field is limited to 80 chars.   Seems like it would be wiser for them to remove some of the whitespace between the columns than to truncate the IP and I’m sure others have made the mistake as I did by grabbing


tcp        0     91 ::ffff:   ::ffff: ESTABLISHED really should be  Never noticed this until I was looking at tcpdump.

A better command to run than netstat is ss, that will also display the correct IP.  man ss for more detailed help.