|
Easy Date and Time Entry in Excel
A reader writes:
"How do I format a cell so that I can input 08212007 with no dashes or slashes and have it appear in the spreadsheet cell as 08/21/2007? No matter how I try to format the cell I get different numbers that bear no relationship to the date I want. Maybe I need a formula? Any help would be greatly appreciated."
For the solution, go here.
For more Solutions, go here.
For more useful tips, check www.pcmag.com/tips (and scroll down to search Tips by category).
E-mail askneil@ziffdavis.com for questions about operating systems or software.
E-mail askloyd@ziffdavis.com for questions about hardware.
E-mail ZDI_Subscriptions@ziffdavis.com for questions about your newsletter subscription.
To ensure you don't miss a response, please make sure to add ziffdavis.com to your spam filter's whitelist.
 | SUBSCRIBE TO PC MAGAZINE AND SAVE 82%
Subscribe today and save 82% off the newsstand price. Plus, you will receive FREE software from PC Magazine with your subscription. Don't miss this limited time offer.
PC Magazine is America’s #1 technology magazine, delivering authoritative, lab-based comparative reviews of technology products and services to more than 6.6 million professionals every issue.
|
To find out more about what's going on in the world of technology, check out www.pcmag.com throughout the day!
ADVERTISEMENT
 |
 The PCMag.com Bookstore
PC Magazine's Windows Vista Solutions
We've got all the answers you need to get the most out of Microsoft's new OS. In our Windows Vista Solutions book, we'll help you pick the right version of Vista, optimize it for maximum security and/or flexibility, and configure it to suit your work habits. Also, learn about new features and applications like Windows Photo Gallery, Media Player 11, and Internet Explorer 7.
PC Magazine's Office 2007 Solutions
Want to get the most out of your new Office suite? Struggling to make sense of the Ribbon? Let PC Magazine show you how with our Office 2007 Solutions book, with tips and shortcuts for the apps you use the most during your workday: Word, Excel, PowerPoint, and Outlook. Learn how to safely install the suite and keep it up to date, integrate it with Windows Vista, and use even the most advanced features.
More Books
| FEATURED OFFERS | | |  | Increase Productivity With Online Backup
| Learn how Dreambuilder Investments uses MozyPro to focus on higher-level business operations, increase quotas, add new users, save more than $5,000 each year, and help them safeguard against disaster.
Read More | | | | |
eNewsletter Information
You are subscribed to PC Magazine Tip of the Day with the email address ignoble.experiment@arconati.us. Click here to unsubscribe from this newsletter.
To subscribe to other e-mail newsletters from Ziff Davis, change your delivery format from HTML to text, or change your email address, click here.
Copyright © 2008 Ziff Davis Media, Inc. All Rights Reserved.
Ziff Davis Media Inc., 28 East 28th Street, New York, NY 10016
| | FEATURED VIDEO | | Plus, Icahn's big bet on Yahoo hinges on Microsoft sale, Your Complete Father's Day Gift Guide and more! More Videos>> | PCMAGAZINE UTILITY DOWNLOADS SPECIAL OFFERS Find the ThinkPad that fulfills your business requirements! Click here today! Special Offers Now on Thinkpad® and Lenovo 3000 PCS.
Save Now > Free White Paper:
A Smart Server Strategy for Small and Mid-Sized Businesses
Learn More!
|
No comments:
Post a Comment
Keep a civil tongue.