Evidently, you've never heard of preformatting the destination as text... Content like '24-7' pasted from another application will remain '24-7'. Likewise, it seems you've never explored the 'Paste Special 'options, one of which is 'Keep source formatting'...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Both of which are broken. I can either not get the dates and lose the rest of the formatting, or get the dates: https://youtu.be/1h35UT4kAzU

If something is broken on your PC, maybe you should fix it instead of complaining that Excel is flawed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Exactly

Tested from Notepad , works perfectly

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Pasting into Notepad first removes the formatting, so this is again not a solution.

Entered a string like 24/7 in notepad then copy pasted to a pre-formatted text sheet, works perfectly.

This is getting us nowhere.

Seeing the way you react and your overall lack of courtesy for those trying to help you for free on their free time, I am adding you to my "ignore list".

Good luck with your query

Thread closed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post