I am importing an excel file into a table the currency column is setting to varchar2 which is fine and has $1,000.00 as the value.
when the column is edited in excel you only have to type 1000 and it looks like $1,000.00
but in apex 20.2 interactive grid when you edit the column and put in 1000 it still looks like 1000.
If I set the format mask to FML999G999G999G999G990D00 it does not have any effect..