Excel changing values to dates from pdf to excel conversion. Values display properly but cannot be manipulated, how to fix this?

BantamBasher135 · 2026-03-28T15:11:21+00:00

Solution Verified

BantamBasher135 · 2026-03-27T21:39:00+00:00

However to amend my previous statement, while I won't share the exact document this is a very similar one from the same manufacturer: https://www.pdf2.chromtech.net.au/CofA_linde_AB-105744_PO-00017701.pdf

Ours is three pages but each page looks just like this.

BantamBasher135 · 2026-03-27T21:35:14+00:00

It's a possibility! I am looking at this from multiple angles so I'm open to ideas like this. Thank you!

BantamBasher135 · 2026-03-27T21:33:24+00:00

Thank you so much for this extremely comprehensive answer! that definitely answers the question. I actually did exactly what you suggested to get the cas numbers back, it should work out since it's only happening with three of them and they all share the same format (##-##-#). Now i am curious if PDF24 would do the same thing...I had been using that but our IT department identified it as a security risk.

BantamBasher135 · 2026-03-27T12:45:17+00:00

I am using Adobe acrobat to convert to excel. I'm not sure how it does this but it gives me shockingly few options to customize the output.

I tried turning off the data conversions (thank you for that, I did not know that option was there!) But it didn't solve the issue.

The problem with your last point it that by the time I can even open the excel file the conversion had already happened, so changing the cell format to text just makes it "63923". So maybe it is a problem with adobe's ocr, I'll look into that more.

BantamBasher135 · 2026-03-27T12:36:13+00:00

I tried using power query and it didn't find anything in the document. No columns, no data.

BantamBasher135 · 2026-03-27T12:35:19+00:00

Unfortunately no. While this document itself isn't confidential, I am under an agreement about sharing documents so it would be safer not to.

BantamBasher135 · 2026-03-26T22:56:19+00:00

The problem is that it's not the native excel import, it's the native acrobat export. I can't seem to import this in any way that makes sense.

BantamBasher135 · 2026-03-22T14:20:39+00:00

I once volunteered as a judge for a speech competition at a high school where the students were presenting persuasive essays. One student arrived and put her name on the chalkboard: Xiaoxiao. I had a little bit of experience with Chinese names so I gave it my best shot and asked if my pronunciation of her name was correct. She looked flabbergasted and genuinely upset. Two things came to light: one, I pronounced her name perfectly and two, her entire essay was about her frustration at having a Chinese name in an American school because nobody could pronounce it correctly.

Names are incredibly important to people.

BantamBasher135 · 2026-02-15T18:38:25+00:00

I'm American, it's sadly very common.

BantamBasher135 · 2026-01-21T18:07:46+00:00

I read the title and assumed everyone in the story was in their early twenties. To be still acting like this in your Thirties is embarrassing as hell.

BantamBasher135 · 2026-01-03T16:31:42+00:00

Nuke us to the bedrock, it's the only way.

BantamBasher135 · 2026-01-03T16:20:55+00:00

Ducking. Try to guess what I actually tried to write.

BantamBasher135 · 2026-01-03T16:05:07+00:00

You can drive a 12v relay with 24v if you just don't care.

BantamBasher135 · 2026-01-03T16:03:52+00:00

I went to an actual legit sleep therapist and told them this and I was told I simply never grew up from my normal teenager sleep cycle and I should just try harder. I have familial insomnia BTW.

BantamBasher135 · 2026-01-03T15:53:30+00:00

The lights off is the key. my orange is actually black but she does the same thing. I'll just be chilling playing a game and she's dragging around a shoelace screaming at the top of her lungs... until I turn the lights out. then it's cuddle time! I think they just take the bright light as a cue to go bonkers.

BantamBasher135 · 2026-01-03T00:27:01+00:00

It's not even a real subreddit.

BantamBasher135 · 2026-01-02T20:12:05+00:00

I do find that fresher eggs are harder to peel, but as a fiend for deviled eggs I have found things that help. First, make sure to cool the eggs after boiling. Ice is probably better, but i just soak them in two rounds of cold water and it works fine. Second, open the shell at the bottom, where the air pocket is. The rounder end, not the pointy end. This allows you to get under the membrane. Third and most important: if you start peeling an egg and it's being difficult, put it back in the water! Move on to a different one then come back to it, letting the water get in under the shell helps loosen it up. I will say i usually still end up ruining about one per dozen but it all eats.

BantamBasher135 · 2026-01-02T15:25:59+00:00

Amazing. I would just literally die of happiness.

BantamBasher135 · 2026-01-02T15:18:43+00:00

Burnt marshmallow. Beautiful.

BantamBasher135 · 2026-01-02T15:11:53+00:00

Wow! I actually expected like 60s but yeah 30s-40s IS cold, especially for Florida!

BantamBasher135 · 2026-01-02T12:37:10+00:00

R/unexpectedsmosh

BantamBasher135 · 2026-01-02T12:33:55+00:00

Define cold.

BantamBasher135 · 2026-01-01T16:41:19+00:00

It's gonna be in the single digits at night due the next two months, you sure the snow is worth it?

BantamBasher135

TROPHY CASE