{"id":12017,"date":"2022-11-03T09:16:20","date_gmt":"2022-11-03T09:16:20","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=12017"},"modified":"2024-03-26T11:06:24","modified_gmt":"2024-03-26T11:06:24","slug":"convert-long-numbers-to-text","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/convert-long-numbers-to-text\/","title":{"rendered":"Convert Long Numbers to Text in Excel"},"content":{"rendered":"\n
When you type a number that has more than 15 digits in a cell in Excel, Excel converts any digit beyond the fifteenth position to a zero.<\/p>\n\n\n\n
This can render invalid, for example, a credit card ID number that contains more than 15 digits. You can avoid this problem by converting long numbers to text. This tutorial shows two methods of how to convert long numbers to text in<\/a> Excel.<\/p>\n\n\n\n This method is suitable for small datasets.<\/p>\n\n\n\n Suppose we have the following information about clients\u2019 credit card ID numbers in a Word table:<\/p>\n\n\n\nMethod 1: Precede the Numbers with Single Quotation Marks<\/h2>\n\n\n\n