I has created a list of customers in Ms Excel. It is an sheet which gives information of the address of customers located in different areas. Normally the data has a mixed characters of alphabets and numbers. Here there is problem in the the column of customer id. I tried to correct it but no results. It is showing a small marks at the end of cell denoting numbers are stored as text. While copying the information to certain place the numbers changes like 2.30 goes to 2.3. This makes a big difference. What is the way to display the numbers as text only excel sheet and restore back to numbers if don't required. Reply.
Bookmarks