As long as the cells contain valid dates, whether or not they are formatted
as Text, this will work.

in B1, C1, D1 enter

=MONTH(A1)
=DAY(A1)
=YEAR(A1) or for 2-digit year use =RIGHT(YEAR(A1),2)

then copy B1:D1 down to the last row.

HTH
Charlie

" wrote:

Thanks in advance for the advice.

I have rows of cells, each contains a date i.e. 3/18/08 (some dates
are formatted as such: 3-18-08). I believe however that excel
recognizes them as text or numbers not as actual dates though.

So, let's say the text is 3/18/08. This is all in cell A1. Is there
any way I can get excel to automatically input into cell B1: 3, into
cell C1: 18, and into cell D1: 08?

It doesn't seem like much of a chore but when you've got thousands of
rows of dates, it gets a bit tedious to do it by hand. The thing is,
I copy this dated information from a word file, and obviously each
date (in a seperate line in Word), gets copied into one cell.

Thanks