editing price type cell

I define a column type as price. when I edit the cells in that column, i noticed that the cell value will not be changed if any of the alphabetic characters are typed in. Is there any way I can alert the users when they type in any alphabetic characters ?


You can use onEditCell event to show any custom message after edit operation.
Instead of showing message you can just remove any not-numerical characters

    if (stage==2 && index==INDEX){
       return value.toString().replace(/[^0-9,]+/g,"")
    return true;

where INDEX - index of column in question