Jan 19 2022 09:20 AM
Why in a personalized number format like this:
#### #### #### ####
excel substitutes automatically the last number with a zero (0) ?
I want to format credit card numbers this way, leaving a small space between groups of 4 numbers, it then shoud show this way: 1234 5678 9012 4444
but no matter what I do, it always shows 1234 5678 9012 4440 substituting with a 0 the last number.
Anyone has a suggestion?
Jan 19 2022 09:36 AM