<div>
some of the people that were hired in 1979 are coming back as hired in 2079.<br />
<br />
the year column says 79 &nbsp;but in actuality it was 1979<br />
the formula comes back with it saying 2079<br />
its dang close tho
</div>


some of the people that were hired in 1979 are coming back as hired in 2079.

the year column says 79  but in actuality it was 1979
the formula comes back with it saying 2079
its dang close tho

<div>
Have you tried my suggestion at ID:37040054?<br />
<br />
It worked well.<br />
<br />
<br />
Sincerely,<br />
Ed
</div>


Have you tried my suggestion at ID:37040054?

It worked well.


Sincerely,
Ed

<div>
<div class="content wysiwyg-content">
i have 3 columns<br />
in column a i have the month<br />
in column b i have the day<br />
in column c i have the year &nbsp;(only 2 places)<br />
<br />
for instance. &nbsp; <br />
my data<br />
a (month) &nbsp; b(day) &nbsp; c(year) &nbsp; &nbsp; what i am trying to get in one column<br />
&nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/24/2004<br />
&nbsp; &nbsp; &nbsp;11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8 &nbsp; &nbsp; &nbsp; &nbsp; 99 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/8/1999<br />
<br />
so the third column is tricky.... it only has last 2 digits of the year
</div>
</div>


i have 3 columns
in column a i have the month
in column b i have the day
in column c i have the year  (only 2 places)

for instance.   
my data
a (month)   b(day)   c(year)     what i am trying to get in one column
     5               24          4               5/24/2004
     11               8         99              11/8/1999

so the third column is tricky.... it only has last 2 digits of the year

3 columns of calendar data to make a date in another column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.