Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Adding a Little Animation to Your Life
Converting a Range of URLs to Hyperlinks
Making the Formula Bar Persistent
If you are using Excel to massage data imported from another system, you know that often the data needs quite a bit of work. For instance, you might import information that represents a time value, but the data actually ends up being treated by Excel as a text string.
If you find your data in this condition, all is not lost. If you want to convert the text values into actual time values, there are several ways you can accomplish the task. The first is to follow these steps:
=VALUE(A1)
Once you get going with this process, it is pretty quick. Not as quick, however, as the following approach:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2745) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.