I have this credit card number in a Google Sheets of the following format:
XXXXXXXXXXXXXXXX
How can I make it display like XXXX XXXX XXXX XXXX or XXXX-XXXX-XXXX-XXXX where they're in four digit blocks?
Google Sheets Formatting – How to Format Credit Card Numbers as Four Digit Blocks
formattinggoogle sheets
Related Solutions
This option is only available in the "new Google Sheets".
In the new Google Sheets, you can apply custom formatting for currencies, dates, and numbers.
cf https://support.google.com/drive/answer/56470?hl=en
To activate the new Google Sheets, you can follow those instructions: https://support.google.com/drive/answer/3541068
The following custom number format mask will produce the desired results without losing the accuracy of the underlying value.
[>999999]0.0,,\M;[>999]0.0,\K;0
Related Topic
- Google-sheets – How to auto format a phone number with an associated hyperlink in Google Sheets
- Google-sheets – Format Google Analytics Date
- Google Sheets – Display Only Last 4 Digits
- Google-sheets – Google sheets – display only rows containing a digit in range [1-9]
- Google-sheets – Google Sheets on PC Copy/paste using “Paste Values” (Crtl+shift+V) appears to work but numbers are not treated as numbers in GRAPHS
- Google Sheets Formatting – Why Can’t These Strings Be Formatted as Numbers?
- Google-sheets – How to format a column of 3 and 4 digit numbers to add a 0 in front of any 3 digit numbers so they are all in 4 digit format? Google sheets
Best Answer
With dashes (
-):=CONCATENATE(LEFT(A1,4)&"-"&MID(A1,5,4)&"-"&MID(A1,9,4)&"-"&RIGHT(A1,4))or with spaces (
):=CONCATENATE(LEFT(A1,4)&" "&MID(A1,5,4)&" "&MID(A1,9,4)&" "&RIGHT(A1,4))