I am using latest version of Oracle Apex Cloud.
Problem is in interactive grid numeric field returns NaN after leaving.
I applied format on it and it was working but as soon as I applied to just let it accept numeric values it started giving NaN.
for numeric values to enter only I have used your codes. It works only if numeric only applied but if try to apply both (numeric only and format) than it gives NaN.