Hi, I have a list of dates (approx 500 rows) on an excel spreadsheet that I
want to convert to values, how can I do this through VBA?
Date format (if it makes a difference) is for example Wed-Oct-08 and what I
want is the cell next to it to show as Wed in text (not a number, then
formatted)
Many thanks for help

Is your Wed-Oct-08 entry a *real* Excel date with the cell formatted to look
like that or is it just a text entry? Select one of the cells with that
"date" in it and what do you see in the Formula bar... exactly what is in
the cell or something that looks like a normal date? If a normal date, then
(assuming the date is in A1) put =TEXT(A1,"ddd") in, say, B1. Or, again if a
normal date, you could put =A1 in B1 and custom format the cell with ddd. If
it is strictly text, then put =LEFT(A1,FIND("-",A1)-1) in B1.

--
Rick (MVP - Excel)


"JohnUK" <(E-Mail Removed)> wrote in message
news:C356D22A-E9C2-4696-BDC6-(E-Mail Removed)...
> Hi, I have a list of dates (approx 500 rows) on an excel spreadsheet that
> I
> want to convert to values, how can I do this through VBA?
> Date format (if it makes a difference) is for example Wed-Oct-08 and what
> I
> want is the cell next to it to show as Wed in text (not a number, then
> formatted)
> Many thanks for help
>

Many thanks Rick, the TEXT ("ddd") done the trick.
Regards
John

"Rick Rothstein" wrote:

> Is your Wed-Oct-08 entry a *real* Excel date with the cell formatted to look
> like that or is it just a text entry? Select one of the cells with that
> "date" in it and what do you see in the Formula bar... exactly what is in
> the cell or something that looks like a normal date? If a normal date, then
> (assuming the date is in A1) put =TEXT(A1,"ddd") in, say, B1. Or, again if a
> normal date, you could put =A1 in B1 and custom format the cell with ddd. If
> it is strictly text, then put =LEFT(A1,FIND("-",A1)-1) in B1.
>
> --
> Rick (MVP - Excel)
>
>
> "JohnUK" <(E-Mail Removed)> wrote in message
> news:C356D22A-E9C2-4696-BDC6-(E-Mail Removed)...
> > Hi, I have a list of dates (approx 500 rows) on an excel spreadsheet that
> > I
> > want to convert to values, how can I do this through VBA?
> > Date format (if it makes a difference) is for example Wed-Oct-08 and what
> > I
> > want is the cell next to it to show as Wed in text (not a number, then
> > formatted)
> > Many thanks for help
> >
>
>