Share via

Excel: Display numbers as credit card numbers

Anonymous
2023-03-27T18:35:51+00:00

I followed instructions in Display numbers as credit card numbers - Microsoft Support and entered as text, but it does not show as numbers. It's a combination of numbers, letters, punctuation and symbols. Please advise. Thank you.

Windows for home | Windows 11 | Files, folders, and storage

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2023-03-28T03:26:08+00:00

    Dear Sotar Rua

    Welcome to Microsoft Community.

    By your description, you want to enter a sixteen digit credit card number in excel. Since excel will not display numbers longer than fifteen digits, only the text format will support you in displaying sixteen digits.

    Your problem may be caused by an incorrect setting of the cell format. If it is convenient for you, could you share with me a screenshot of the screen where you are getting the error in your reply?

    In order to better assist you with your problem, I need to identify the following requirements from you. <br><br> <br><ul><li><p data-prewrap="true">Do you want the sixteen digits to be fully displayed? Or do you want to obscure some of the sixteen digits? </p><p data-prewrap="true"></p></li><li><p data-prewrap="true">Do you want to add symbols to the sixteen digits? For example, 1234-5678-1234-5678 </p></li></ul>
    If you want to display your sixteen digits fully, you can follow these steps: <br><br> <br><ul><li><p data-prewrap="true">Set the cell where you want to enter your credit card number to text format</p><p data-prewrap="true"></p><p data-prewrap="true"><a href="https://learn-attachment.microsoft.com/api/attachments/6af14f00-7268-4bd0-8a0c-54463a94eac7?platform=QnA
    1 person found this answer helpful.
    0 comments

    1 additional answer

    Sort by: Most helpful
    Most helpful Newest Oldest
    1. Anonymous
      2023-03-28T11:22:31+00:00

      Worked Lucy, thank you!

      If you want to display your sixteen digits fully, you can follow these steps:

      • Set the cell where you want to enter your credit card number to text format Image
      0 comments