Format Exports to Match - Custom/Text

Good afternoon. I have two exports that I'm trying to make work together, but the differing formats are causing me issues. One is a PDF that I convert to Excel. These cells are automatically formatted as Custom values. I have numbers that appear as "0100" but are only "100" when you actually select that cell. I then take another export from our company software (JD Edwards) and drop it into the same workbook. These are formatted as Text, so "001" is actually "001". The goal is to get the formats aligned so that a VLookup is possible, but it doesn't seem as simple as changing the format of the first export to Text. I'm wondering if there's a way to capture the "0" that doesn't really exist in this first export so that it doesn't disappear when I change the format.

Please let me know what information I'm not clearly conveying and I'll do my best to clear it up. The ultimate goal is to create a workbook where the employees can dump both of these exports into two worksheets and their copy/paste information will be summarized on a third worksheet. If you need a sample uploaded, I can do that as well. Thanks in advance

Thanks for the input. Here's the thing, our GL codes sometimes begin with a 0. So I need to keep the 0's in there in order to ensure I don't create an issue between accounts. One account could be 01250 and another could be 1250. Let me know what you think about this, please.

I'm opening the PDF and selecting File>Save As Other>Spreadsheet>Microsoft Excel Workbook. The only other option it gives under Spreadsheets is XML Spreadsheet 2003. I tried saving as that just now before replying and received the same result, "0100" that's really "100."

We're using Adobe Acrobat Pro. They use Excel to create these reports, they just save them as PDFs to prevent further changes. If we can't find a way to align the formats, we might just have to start leaving them in Excel.

That did it. It landed the values in the format we need them. We can manipulate it the rest of the way to serve our needs. Thank you very much for the time and information!