Typically in Excel, if we design a worksheet with a number stored as text, then we have made a conscious decision to do so. Consequently it is very annoying to see this error every time we see a number stored as text.
A valid use case would be a product or part number, which may be preceded by zeros, or a telephone number with the same convention. Alternatively we may be considering permutations of ones and zeros in which case preceding zeros are valid informational content.
To get rid of these errors:
File
Options
Formulas
Error Checking Rules - Deselect "Numbers formatted as text or preceded by apostrophe"
Job done.
A valid use case would be a product or part number, which may be preceded by zeros, or a telephone number with the same convention. Alternatively we may be considering permutations of ones and zeros in which case preceding zeros are valid informational content.
To get rid of these errors:
File
Options
Formulas
Error Checking Rules - Deselect "Numbers formatted as text or preceded by apostrophe"
Job done.
No comments:
Post a Comment