Leads zeros dropped when syncing UPCs

[fishtech]

Hi,

I sync an indexed number field which contains UPC codes such as 000112223333.

After a sync the UPC's lead zero's are truncated in the destination record. For example, 000112223333 becomes 112223333.

Is there a way to work around this please?

Thanks,

ft.

Edited January 17, 2017 by fishtech

[webko]

000112223333 is not a number (try using the Data Viewer - GetAsNumber ("000112223333") )

You would need that to be a text field to preserve the leading 0's

[Jesse Barnum]

What webko said. Change the field type from number to text.