Results 1 to 7 of 7

How to enter custom format for both current date and time in cell?

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2010
    Location
    somewhere, USA
    MS-Off Ver
    Excel 2010
    Posts
    86

    How to enter custom format for both current date and time in cell?

    I know we can enter a date and time into a cell separately. But I'd like to create a custom format that allows me to enter both the date and time stamp concurrently in one cell. However when I select the custom format and create such a format it enters the date correctly but not the time. The time defaults to 12:00 PM even though I'm asking for the custom format to time stamp the current time into that cell using the custom format.

    What am I doing wrong? Is there a way to get a custom formatted cell to input both time and date stamp correctly simultaneously in the same cell or do I have to create a separate cell for the time stamp? Thanks in advance.
    Last edited by DorothyFan1; 10-08-2011 at 08:16 PM.

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