Excel changing values to dates from pdf to excel conversion. Values display properly but cannot be manipulated, how to fix this?
Like the title says, I have a pdf of a scanned document which is a list of chemicals including CAS numbers ( ex. 75-01-04) that I have converted into excel. When I open the excel file, all the cas numbers *look* right, but when I try to copy or format them some of them turn out to be changed into numbers as excel dates ( ex. 63923).
I can't seem to change how Adobe formats it on export, and there's no way to turn off this obnoxious excel formatting, so what can I do? The whole point of this is to automate the paper copy-> excel process but if it is fundamentally changing these values then the process is worthless.
I have tried power query and it says the document is empty so that's not an option either.
Ideas?
[link] [comments]
Want to read more?
Check out the full article on the original site