Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Should leading zeroes be used for data record fields that are less than the maximum length?

April 26, 2017Data Fields Leading LENGTH maximum record Used zeroes

0

Posted

Should leading zeroes be used for data record fields that are less than the maximum length?

1 Answer

0

Posted

No. In order to maintain consistency and to provide more stability for the system administrators who are importing data records, it was decided that numeric fields should not include leading zeroes. So the value two dot one seven per cent should be shown as 2.17, not 02.17.