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

Here is a formula to go in Cell B1 that references cell A1...

=DATE(YEAR(NOW()), MONTH(NOW()), A1)

Note that Now is a volatile function so that it will recalculate each time
the spreadsheet is opened and they year and month will change accordingly. I
am not too sure if that is what you want or not. If not then

=DATE(2007, 9, A1)
--
HTH...

Jim Thomlinson


"GKW in GA" wrote:

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

Set the date cell to text and then concatenate(Ax," ","blah")

God Bless

Frank Pytel


"GKW in GA" wrote:

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