Retaining date format when pasting to Notepad (from Excel)

Hello,

The formatting of the dates in my Excel data are lost when pasted to Notepad. The Excel data date format is YYYYMMDD but pasted into Notepad in the MM/DD/YYYY. I know my code only copies/pastes values, not formats. Can someone help?

Please Login or Register  to view this content.

Here you go, the chunk of relevant code. Basically I check to see if it's a date. If true, format it like I want it (YYYYMMDD), then cast it as a String. Since it is just a string at that point, the formatting shouldn't change in notepad.

Please Login or Register  to view this content.

Yay!!! It worked!!! Thank you soooo much! I almost gave up on this...you are a lifesaver

Great! Reputation is appreciated (the star a the bottom left of my posts), and don't forget to mark this thread as SOLVED.

Done

How do you mark this as solved? Sorry, I'm new lol.

Originally Posted by blondeambition

Done

How do you mark this as solved? Sorry, I'm new lol.

I figured it out, thanks again walruseggman!