Excel Tips – How to Convert Text to Numbers in Excel 2010


Excel Tips How to Convert Text to Numbers in Excel 2010 In this tutorial we will cover how to both detect text and then convert text to numbers in Excel 2010. Quick Keyboard Trick to Detect If Cells Are Numeric or Text A cool trick to detect text in a series of numeric values is using CTRL+SHIFT+# to quickly convert them to dates DD-MMM-YY format.  Only the numeric values will be convert to text, otherwise they will remain unchanged. Once you have detect if cells are text, there are some tricks you can use to quickly convert text to numbers. .video-container{text-align:center;} How to Convert Text to Numbers There are several ways to create a checkmark or checkbox in an Excel worksheet. Here are a few of them. You may find that sometimes after you import or copy data from a database or other external source, the numbers in your worksheet are actually stored in cells as text. This can cause problems with calculations and sorting, among other things. A telltale sign that a number is st
http://bit.ly/1Vyv97B

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s