@spreadsheetnation: Replying to @seandent83 Excel will warn you when it thinks you have text that looks like it might be a number. This can be a helpful warning since numbers stored as text don’t work very well with formulas and sorting. However, you may want to turn those warnings off. You can turn off the warning on individual cells by selecting the cell and clicking the box next to it. Then choose Ignore Error. This works when you select multiple cells too. If you always work with ZIP codes or other numbers where number formatting doesn’t matter, you can always turn those warnings off. To do so, click File and then Options. Go to the Formulas section and then the section called Error checking rules. Uncheck the box for numbers stored as text and then you’ll never see that warning again. You should be careful about turning off all warnings, as numbers stored as text can be a problem and being warned about it might be useful. #excel #googlesheets #workhacks

Spreadsheet Nation

Open In TikTok:

Region: US

Monday 22 January 2024 15:29:19 GMT