0

I've just noticed that when trying to use a custom formatting for, say, 16-digit credit card number, something really strange occurs:

Screen Recording

Can someone explain what's happening and why it keeps defaulting to the special formatting? And how can this be mitigated?

Note: I guess the mouse pointer doesn't get recorded in screen capture, so please ignore the pauses.

2
  • What's the unexpected behavior?
    – Alex M
    Oct 29, 2019 at 23:50
  • After applying the custom formatting, then returning to the cell formatting screen, the cell format has automatically changed to one of the Special grouping's format?
    – Arctiic
    Oct 30, 2019 at 9:44

1 Answer 1

0

The custom number format that you entered corresponds to the special format that appears when you re-select the cell. That will happen whenever you enter any previously defined format.

2
  • And this is a predefined format that ships with Excel? Is there no way to diable or remove it?
    – Arctiic
    Feb 17, 2020 at 3:43
  • Why would you want to remove it? In any event, it's not doing anything since you are entering your value as a text string. Feb 17, 2020 at 13:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .