Skip to main content
My system region settings 
IFS region settings
 

When i output data to excel  from payroll history overview screen for the field " amount" having more than 6 digits ---in excel amount field is displaying as zero "0"....i need amount value field to be displayed same as front end and with comma separated value. Any solution ?

Hi @Roshini,

How did you export your data to excel?

I tried a similar action, and it worked for me. Please try to export into excel by actins described in the below image, follow from steps 1 to 3.

 

 

Thank you shardha, 
But I already tried same way to output data , but it doesn’t work.

Please try below options:

  1. Try the same in a different PC.
  2. Export the selected records using custom export option, in Output window, into csv. Open the csv file using Notepad and see whether the numbers with more than 6 digits are there.
Terms & ConditionsCookie settings