What is the rule of number format? frormatCode like this 0E+,\q0

guji wang 1 Reputation point
2021-10-22T10:09:34.653+00:00

hi all!
I found an Excel's bug, formatted data: "5e, q-1", wait until closed and then open, the data becomes "0e, q + 1"
What is the rule of a digital format? Can you explain this example, thank you

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.