Show Error when a cell with number format change to date format

hi
i have a excel file with a range of number
but sometimes when i open my file some cell change to date format, so i should check my file every time before i sent it to my client
i want to write a formula(like below pic in cell E2) that alert me and show me when cell's format change from number to date



can anybody help me pls

with thanks

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Just press green button and it'll fix all formats in columns that contain JP in 2nd row:

No. Formula cannot give you information of formatting of another cell.