How to remove comma(,) from a Numeric Field

[Vaishnavi35]

Hi ,

I have created a field of name "External Test ID" type "Integer". There is comma appearing which I do not want.

Later when i try to change the type. It is giving Error!

Note : These data were loaded from Excel sheet.

Thanks,

Vaishnavi

[Jaspal Singh · Accepted solution]

Hi Vaishnavi,

You need to pass attribute for the integer field's dictionary as format=none that should do the trick.

Right click the field, configure dictionary & pass attribute as suggested above.

[Vaishnavi35]

perfect! Thank you so much Jaspal.

This will not effect the data i will load later right?

Because i have actually provide the template(excel) to the client?

[Jaspal Singh]

No, its just used for formatting/displaying of data. Should not have any impact.

[Vaishnavi35]

Thanks Jaspal.