Leading Zeros are Removed from Numbers in Excel
  • 24 Feb 2023
  • Contributors
  • Dark
    Light
  • PDF

Leading Zeros are Removed from Numbers in Excel

  • Dark
    Light
  • PDF

Article summary

When I open Excel and look at data exported from FIMS that has leading zeros in FIMS records, those leading zeroes are removed. How can I fix that?


Answer:

This is an issue with Excel and how Excel translates numbers. The article below may help with getting those zeroes added back in:

Leading Zeroes Removed in Excel


Was this article helpful?