Thanks Myrna. Just what I needed! Thanks everybody
g:)

"Myrna Larson" wrote:

Ah, the problem, then, is that the cell DOESN'T contain an Excel date and time
(which is a number), it contains text:

Dim X as String
Dim i As Long
Dim D As Date

X = Range("E80").Value
i = Instr(x, ",")
D = CDate(Trim$(Mid$(X, i + 1)))


On Tue, 26 Oct 2004 06:17:11 -0700, "gaba"
wrote:

Thanks JulieD and Bob for your answers... still not working. I can't believe
something so simple is giving me such a hard time. I think I know what the
problem is. Soon as I take the day part ("Friday,") it works (both solutions)
perfect.
I need to find a way to Left Trim to the first ","

I'll keep trying
:)

"Bob Phillips" wrote:

Presuming you want a VBA solution

With Worksheets("Sheet2").Range("E80")
.Value = Worksheets("Sheet1").Range("A1").Value
. NumberFormat = "mm/dd/yy")
End With

--

HTH

RP

"JulieD" wrote in message
...
Hi Gaba

right mouse click on cell E80
choose format cells
on the number tab choose custom
in the white line top right type

mm/dd/yy
click Ok

Cheers
JulieD

"gaba" wrote in message
...
Hi,
I have this date and time value (Friday, October 15, 2004 10:35:12)
stored
in a cell ("E80"). I need to format it to 10/15/04 and paste it in
another
spreadsheet. What is doing right now is changing to today's day.... I
just
need the date, ignore the time.

I've tried Format(Date, "mm/dd/yy") and this is the one giving me
todays
date...

Help... this formatting date is not making my date ...

--
gaba :)