1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/BantamBasher135
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Excel
#PDF
#CAS numbers
#data conversion
#formatting
#Adobe export
#automate
#scanned document
#chemical list
#power query
#excel dates
#data manipulation
#paper copy automation
#data integrity
#export options
#empty document
Excel changing values to dates from pdf to excel conversion. Values display properly but cannot be manipulated, how to fix this?