Quote Originally Posted by xjohnson View Post
I want to just enter the year in the first cell by typing 2018 and keep it to show 2018.
Well, I guess you can do something like this
Enter manually 2018 in A1 and enter in B1 =A1