If you want to turn a date into text in a specific date format, use the TEXT
function.
If you want the first 5 characters, use the LEFT function.
If you want to concatenate an extra string, use the CONCATENATE function, or
the & operator as shown below.

If you want to do things the other way round you can use the DAY and MONTH
functions to extract those parts, and use
DATE(2007,your_month,your_day) to get a real date in 2007.

If you don't know how any of those functions work, they are all standard
Excel functions and shown in Excel help.
--
David Biddulph

NotGood@All wrote:
Thank you all, I did use "isnumber". Some of the fields (45000) are
date, some text, and some general. So my question now is can
something be written to first; format each cell to a date format,
second, keep the first 5 characters, then add "/2007"

If your data are text strings,
=DATE(2007,LEFT(A1,FIND("/",A1)-1),RIGHT(A1,LEN(A1)-FIND("/",A1)))
and format appropriately,
or =A1&"/2007" if you just want the result as a text string.
--
David Biddulph


"NotGood@All" wrote in message
...
I have inherited a workbook that has some columns where the person
entered the date as 5/21, 6/10.. All the dates are 2007. Is there
a way for me to
add "2007" to each of the rows so the date appears as "5/21/2007"
--
NotGood@All