I was hoping someone could help me out: I have two columns… one w the month (numbered 1-12) the other w/ the year (1939-xxxx) I need the columns combined to read (193901, 193902 etc). However whenever i attempt to do this it comes out 19392 in stead of 193902. I than do a copy/paste value in a new column to change the format to read as a date, however, the year gets changed. I know this might have something to do w/ converting it to txt format, however, ijust can’t seem to figure it out. Any help/feed back would be appreciated.
Thank you!
