Hi,
I have a field in my excel file that can either be a number or text depending on the adjacent cells value.
Currently I use conditional formating to highlight occurances where non numeric values have been entered in cells that are strictly numeric. The numeric values can be a fraction or decimals
My problem is when I enter in the fraction it automatically formats it to a date. Limiting the format of the cell to fractions automatically changes a decimal value to a fraction. Limiting the format of the cell to text prevents my conditional format check from working.
Is there a way to prevent excel from auto formating the cells, or is there another way to validate if the cell contents is numeric. (please note I am already using data validation for another check in these cells so I cannot use these function)
Any help would be greatly appreciated!
I have a field in my excel file that can either be a number or text depending on the adjacent cells value.
Currently I use conditional formating to highlight occurances where non numeric values have been entered in cells that are strictly numeric. The numeric values can be a fraction or decimals
My problem is when I enter in the fraction it automatically formats it to a date. Limiting the format of the cell to fractions automatically changes a decimal value to a fraction. Limiting the format of the cell to text prevents my conditional format check from working.
Is there a way to prevent excel from auto formating the cells, or is there another way to validate if the cell contents is numeric. (please note I am already using data validation for another check in these cells so I cannot use these function)
Any help would be greatly appreciated!
