Format % in listview

  • 22 May 2020
  • 1 reply
  • 2 views

Badge +7

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%)


1 reply

Hello,


 


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?


 


Thanks


 


 

Reply