Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2015, 06:17 AM
markg2 markg2 is offline Day date and time cell display Windows 7 Day date and time cell display Office 2007
Expert
Day date and time cell display
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default Day date and time cell display

Office '07

My intent is to have a cell display the current date and time.

I first use the shortcut 'ctrl + ;' to enter the date, then I hit the space bar and then I use 'ctrl + shift + :' to enter the time.

while I'm hightlighting the cell, the correct date and time appear in the top of page data bar that reflects cell contents, but only the date appears in the actual cell. When I leave the cell, again, only the date appears.

This is not a formatting condition. I can shrink the point size all the way down and still only the date appears in the cell?

Mark
Reply With Quote
  #2  
Old 02-11-2015, 06:36 AM
gebobs gebobs is offline Day date and time cell display Windows 7 64bit Day date and time cell display Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

If I'm not mistaken, it is a formatting issue. Not the font, but the number format. From the Home tab on your ribbon, press the little boxy thing with the arrow on the bottom right of the Number section to open up the Format Cells dialog box.

In the Category list box, select Date if it is not already selected. Then scroll through the available formats in the Type list box. Otherwise, choose custom in the Category list box and make your own.
Reply With Quote
  #3  
Old 02-11-2015, 06:57 AM
markg2 markg2 is offline Day date and time cell display Windows 7 Day date and time cell display Office 2007
Expert
Day date and time cell display
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

You're correct. Scrolling down the Date options there's a format(s) for Date + Time.

Thanks,

Mark
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Day date and time cell display date & time of last time a recent file was used pgeorgilas Word 1 10-31-2014 08:59 AM
Day date and time cell display Excel 2013 – need help extracting date and time from text cell plus more. Art Mann Excel 1 07-18-2014 09:55 PM
Day date and time cell display Parse date and time from one cell and paste it to another for all files in a folder? chrisd2000 Excel Programming 3 07-03-2014 10:56 AM
How to format cell in order to display *both* time and date SamyCode Excel 3 01-22-2013 03:30 PM
Milestones: Display of - turning off the display of the date Pmacdaddy Project 3 01-18-2013 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft