Wednesday, May 27, 2009

[TechRepublic] Prevent Excel from turning fractions into dates

May 27, 2009
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.

Do 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

Live 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
TROLOV 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.

Get the latest community updates, product reviews, and need-to-know lists in the following TechRepublic newsletters.

Automatically sign up today!

TechRepublic Today

10 cool tools in Windows 7
10 ThingsThe 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.RSS

Get more from TechRepublic

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.

No comments:

Post a Comment

Thanks for understanding that we need to prevent the nasties.

Terms of Use

Personal & Educational Use Only This blog consists mainly of FREE newsletters from computer web gurus that I receive. I thought you might like to see them all in one place than try to discover them on your own. A moderate amount of editing may be done to eliminate unrelated repetitious ads or unnecessary text which bloat the post. However I have given the authors full credit and will not remove their site links because you deserve to see where it comes from and they deserve to get credit for what they have written. Your use of this site is simply for educational purposes. For more computer-related help go to: CPEDLEY.COM for free software, advice and tips on low cost products which are very helpful. If you want to contact the editor, please go CPEDLEY.COM and check the Contact page for email address.