+ Reply to Thread
Results 1 to 3 of 3

Replacing

  1. #1
    Ozgur Pars
    Guest

    Replacing

    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


  2. #2
    Bob Phillips
    Guest

    Re: Replacing

    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
    >




  3. #3
    Ozgur Pars
    Guest

    Re: Replacing

    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
    > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1