removing commas in numbers

[scottjus82]

Morning all,

I am importing some data from an old system into ServiceNow, the reference number from the previous system will go into a custom field in ServiceNow. This is working however it is adding a comma so the number becomes 32,546 instead of 32546. How do I stop this happening?

Regards

[amacqueen]

Steve if you go to the dictionary entry for the field and in the Attributes field enter format=none that should do it.

HTH

[nealratner]

Thanks Angus, that should be the correct answer I believe.

[Annay Das]

I'm very much new to ServiceNow. Could you please assist me step-wise on how to get it done?

[ohhgr]

Hi Steve,

Are you using xls file import to import the data? In that case, you can change the column type to Number may be.

Or you can specify in the import table that this particular field is a number and not a string.

Hope that helps.

-Mandar