I have a column of numbers, eg, 1,3,5,7, etc in column A, I want cell Bx to
be a date in the format current year || current month || Cell Ax, where x is
the row. So if A1 is 1, A2 is 3, A3 is 5, then B1, B2 and B3 would be
20070901, 20070903 and 20070905 respectively

How can I do this