EXCEL CHANGE AUTOMATICALLY TO DATE AND TIME

%3CLINGO-SUB%20id%3D%22lingo-sub-2145908%22%20slang%3D%22en-US%22%3EEXCEL%20CHANGE%20AUTOMATICALLY%20TO%20DATE%20AND%20TIME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2145908%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20writing%20a%20thesis%20right%20now.%20I%20really%20need%20to%20copy%20and%20paste%20a%20lot%20of%20data.%20But%20the%20problem%20is%2C%20every%20time%20I%20copy%20them%2C%20Excel%20always%20automatically%20changes%20some%20numbers%20to%20date%20and%20time%20format.%20It%20really%20frustrates%20me%20because%20I%20only%20have%20a%20time%20limit%20of%202%20days%20to%20copy%20and%20paste%20the%20data%20numbers.%20And%20I%20don't%20have%20the%20time%20and%20power%20to%20change%20every%20single%20number%20Excel%20changed%20to%20format%20date%20and%20time%20to%20normal%20numbers.%20I%20changed%20the%20fromat%20of%20the%20decimal%20number%20from%20dot%20to%20comma%20to%20stop%20this%20bad%20behavior%20of%20Excel%2C%20but%20it%20still%20didn't%20work%20because%20it%20didn't%20change%20the%20format%20of%20the%20data%20I%20copied.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2145908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello,

I am writing a thesis right now. I really need to copy and paste a lot of data. But the problem is, every time I copy them, Excel always automatically changes some numbers to date and time format. It really frustrates me because I only have a time limit of 2 days to copy and paste the data numbers. And I don't have the time and power to change every single number Excel changed to format date and time to normal numbers. I changed the fromat of the decimal number from dot to comma to stop this bad behavior of Excel, but it still didn't work because it didn't change the format of the data I copied. 

1 Reply

@Ariel_Evan 

Hi

 

Not sure where you are copying the data from (presumably a non-excel file?) - however, if you format the all columns in the receiving excel file before you copy and then when you paste select keep destination format this should work.

 

Peter