Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 06-13-2012, 09:45 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Remove time portion in date Windows 7 32bit Remove time portion in date Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Quote:
Originally Posted by Gary Drumm View Post
Just reformat the desired cells (column) using Date 3/14/01 (American)
It will automatically drop off the Time stamp
I'm sure you already know this, Gary, but I'll just elaborate on your suggestion for the benefit of anyone else who's reading the thread....

You have to be really careful with this option. If you just reformat the cells then it's important to understand that the times are still stored within the cell, it's just that they're not shown to the user. Of course that might be fine - or it may be a huge headache - depending on what you plan to do with them.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Shortcut for date/time insert normle Outlook 1 03-25-2012 09:30 PM
Remove time portion in date Shortcut for date/time insert normle Office 4 03-23-2012 05:15 AM
Remove Portion of Field Labels sbianco Word 5 03-07-2012 04:52 AM
Using Date and Time (Timestamp) as a bullet m2oswald Word 1 02-07-2012 03:41 PM
Remove time portion in date Sent emails all have same date/time?? Confused Outlook 3 01-07-2011 07:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:22 PM.


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