+ Reply to Thread
Results 1 to 6 of 6

date time stamp - not to change

  1. #1
    Registered User
    Join Date
    03-08-2012
    Location
    south africa
    MS-Off Ver
    Excel 2010
    Posts
    7

    date time stamp - not to change

    i need help with the date time stamp:
    when i type data in A2 i want B2 to automatically add in the time and the date, ive gotten this to work - only problem is when i drag the formula down and i type info in A3 etc it changes all the dates and times to the current date and time, i need each date and time to be different and to be as per what was filled into A2, A3 etc and not change.... please help

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: date time stamp - not to change

    Try this:

    Please Login or Register  to view this content.
    Right click on the sheet tab, select view code, and paste the above onto the code sheet that appears.

    Dom
    Last edited by Domski; 03-08-2012 at 09:48 AM.
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    03-08-2012
    Location
    south africa
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: date time stamp - not to change

    HI, IVE TRIED THAT, STILL DOESNT WORK???
    scanner date
    SDF 03:46:51 PM
    SDFG 2012/03/08 03:46:51 PM
    DFG 2012/03/08 03:46:51 PM

  4. #4
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: date time stamp - not to change

    No need to SHOUT.

    Have a look at the sample file attached. Works fine for me.

    Dom
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-08-2012
    Location
    south africa
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: date time stamp - not to change

    sorry was not shouting - caps was on as i was busy with other stuff, apologies! ive fixed it - in the code i changed it to "time" instead of date and its working now...

    thanks for all your help

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: date time stamp - not to change

    Have you read the Forum rules?

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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