[TechRepublic] Prevent Excel from turning fractions into dates

May 27, 2009

TechRepublic Microsoft Office Suite Trouble viewing this mail? Read it online | Manage my newsletters Welcome: TechRepublic Member Update my profile | Unsubscribe from this mail Blogs | Photos | Downloads | Forums Prevent Excel from turning fractions into dates Left to its own devices, Excel will convert your fractions into dates as soon as you enter them in your spreadsheet. See how you can work around this problem. SponsoredDo a salary check IT Professionals - check your salary on activeTechPros. Be a member and get instant access to salary charts and country reports. * * * * * * * * * * Business Professionals - join activeBizPros and play a part in driving the salary charts. Your input will help us build a valuable resource for you to compare salaries. Hottest new tips Create a quick org chart in PowerPoint When you need an easy way to illustrate a simple hierarchy, consider building an org chart directly on a PowerPoint slide. Here's a look at how to use some basic diagramming tools so you can pull this together in a hurry. Back up Outlook's AutoComplete list Outlook's AutoComplete list is an efficient tool. Better to be safe than sorry: Back up this file regularly. Number report records in Access To improve readability, number records in an Access report. It's as simple as dropping in a text box and setting a few properties. Printing multiple slides on a single page You can save paper by printing multiple PowerPoint slides to a single sheet of paper. The trick is to rely on a printer option rather than on PowerPoint itself. How to simultaneously change a number of Excel values by the same value Modifying a range of Excel values by the same variable can mean a lot of manual updating. Or you can use this built-in feature to update all those values at once. Office challenge: After deleting a message, how can you force Outlook to open the next message automatically? Here's the answer to last week's challenge on opening a specific workbook in Excel, along with a new question to test your Outlook skills. Members' choice Create a custom Word table style for instant formatting Word 2003 offers a gallery of Table AutoFormat styles -- but they may not always suit your needs. See how to build your own style to quickly make tables look exactly the way you want. Popular power tips Add hyperlinks that open in a new window How do I... Turn off overtype with the Insert key in Word? 10 tips for helping users keep Outlook data secure Use Excel's Lookup functions to search a database When Access queries won't update SponsoredLive Virtual Conference: Lowering datacenter costs through server refresh Discover how today's newest generation of rack servers provide extreme performance?along with dramatically reduced IT costs. (IBM) Video: TR Out Loud - May 22, 2009 In the fifth week before the TechRepublic Community Event, Sonja Thompson recaps the weekly highlights on the site, including the top discussions and most active members. TechRepublic Newsletters Get the latest community updates, product reviews, and need-to-know lists in the following TechRepublic newsletters. Automatically sign up today! Community Central Product Spotlight 10 Things White Papers from our partners Do a salary check Yankee Group: Software as a Service dramatically improves CRM success (Oracle) CRM your salespeople will love (Oracle) Enterprise PBX comparison guide (VoIP-News) Live Webcast: Long Live the Firewall! (PC Connection) TechRepublic Today 10 cool tools in Windows 7 The changes to the Windows 7 interface have gotten a lot of play, but some of the new built-in tools are just as compelling. Deb Shinder runs through some of the most impressive enhancements, from the ISO burner to the Biometric Framework to PowerShell v2. Subscribe to the 10 Things RSS feed. Get more from TechRepublic Video: Protect your personal privacy at work iPhone apps are Google's biggest threat in mobile search Vacation? What a quaint concept Video: How CIOs should spend their day Featured Training Courses Microsoft Exchange Server 2007 Managing and Maintaining a Microsoft Windows Server 2003 Environment Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 Managing and Maintaining Server 2008 Configuring Microsoft Office Communications Server 2007 Browse all Training Courses Presented by Global Knowledge Product Spotlight: EverDesk Optima e-mail client EverDesk Optima aims to change the e-mail game by treating individual e-mails more like documents than traditional e-mail clients do. Justin James reviews the application. Sign up for more free newsletters from TechRepublic. To manage your account settings or to remove yourself from all TechRepublic communications, please visit our Subscription Center. The e-mail address for your subscription is cpedley@churchpower.com Unsubscribe from this e-mail | FAQ | Advertise | Privacy Policy   Copyright © 2009 CBS Interactive Inc. All rights reserved. TechRepublic, TechRepublic.com and the TechRepublic logo are registered trademarks of CBS Interactive Inc. Used by permission. CBS Interactive Inc. 235 Second Street San Francisco, CA 94105 U.S.A.