I have list view with formating for coloumns as below:-
Column 1 - Format Number(with 1 decimal)
Column 2 - Format % (with 2 decimal)
When i entered values in column 1 it formated properly e.g. entered value - 12.39 Display value - 12.4
But when i entered value for Column 2 it formatted wrong way e.g. entered value - 12.39 Display Value should be - 12.39% (Actual result - 1239.00%)
It seems you may need to try entering this data as '.1239' instead of '12.39' in order to achieve the value of 12.39%. Have you tried this?