Replacing

[Ozgur Pars]

Hello,
I am replacing the "."(dots) of a date which comes from the system(
example:28.02.2006) with "/" so that my excel does recognize it as a date.

I used to do manualy until recently. When I tried to automate it with VBA I
saw that it is not recognized as a date. When you select the cell and place
your cursor on the fomula line and hit enter it is recognized.
I tried to record a macro and use the code but it generates a code like this
which is not much use to me I guess(since the dates will change):
ActiveCell.FormulaR1C1 = "2/28/2006"

I know it is probably a stupid question but some hwlp would be greatly
appreciated.

Thanks a lot,
Ozgur

[Bob Phillips]

Try

ActiveCell.Value = ActiveCell.Value


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ozgur Pars" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> I am replacing the "."(dots) of a date which comes from the system(
> example:28.02.2006) with "/" so that my excel does recognize it as a date.
>
> I used to do manualy until recently. When I tried to automate it with VBA
I
> saw that it is not recognized as a date. When you select the cell and
place
> your cursor on the fomula line and hit enter it is recognized.
> I tried to record a macro and use the code but it generates a code like
this
> which is not much use to me I guess(since the dates will change):
> ActiveCell.FormulaR1C1 = "2/28/2006"
>
> I know it is probably a stupid question but some hwlp would be greatly
> appreciated.
>
> Thanks a lot,
> Ozgur
>

[Ozgur Pars]

Hi Bob thanks for your reply but it did not work.

Ozgur

"Bob Phillips" wrote:

> Try
>
> ActiveCell.Value = ActiveCell.Value
>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Ozgur Pars" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> > I am replacing the "."(dots) of a date which comes from the system(
> > example:28.02.2006) with "/" so that my excel does recognize it as a date.
> >
> > I used to do manualy until recently. When I tried to automate it with VBA
> I
> > saw that it is not recognized as a date. When you select the cell and
> place
> > your cursor on the fomula line and hit enter it is recognized.
> > I tried to record a macro and use the code but it generates a code like
> this
> > which is not much use to me I guess(since the dates will change):
> > ActiveCell.FormulaR1C1 = "2/28/2006"
> >
> > I know it is probably a stupid question but some hwlp would be greatly
> > appreciated.
> >
> > Thanks a lot,
> > Ozgur
> >
>
>
>