Converting Numbers to Text

February 7th, 2006 by admin admin

You have an Excel worksheet that contains the phone numbers of suppliers and customers. You would like to convert them to text so that you could export these numbers into another IT system. What should you do?

Most users would simply highlight the range of numbers and then format these cells as text. They thought that by doing so, the numbers are all converted to text. THis is not so. When the cells are formated to text, the numbers in these cells remain as numbers. To convert them to text, you need to use the Excel worksheet function called “Text”. Assuming that you have a cell in A1 that contains the number 5. To convert it to text, you need to enter the formula=text(A1,”@”) , including the “=” into the cell say B1. The number 5 will become a text and when you try to sum up this value with others, it will not included.

Leave a Reply

You must be logged in to post a comment.