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.

How do I view numbers with leading zeros when I open EMTS documents in Excel?

April 26, 2017documents EMTs Excel Leading Numbers view zeros

0

Posted

How do I view numbers with leading zeros when I open EMTS documents in Excel?

1 Answer

0

Posted

When viewing EMTS documents in Excel, the leading zeros are dropped from numeric fields like BatchNumberText if the data in the cell is composed entirely of numbers. For example, “00079” will be displayed as “79,” but “00079a” will be displayed as “00079a.” This behavior is a “feature” of Excel.