40
5
I'm copy-pasting some data from html table into excel. But excel automatically converts some text or number values to date! When I change the format, the number is perversed, the number is something like 4112523 (excel probably interprets the cell as date and then converts to number or something like that...)
There is a trick for importing CSV files, but is there any solution when you are pasting your data directly from a web browser?
8The fact that any software thinks the most appropriate way to behave is to assume you want it to reformat whatever information you gave it because surely you didn't mean for it to be THAT way... with no easy and obvious way to disable it... is the single dumbest design decision and annoying thing about Excel. I should not have click through an import wizard if all I am trying to do is copy/paste from one CSV to another. The friggin thing is a number in one CSV. Why on God's green earth would I want it to paste a date? What idiot designed that? – Matt Welch – 2014-08-25T14:55:49.560
2Before pasting, format the whole sheet as text. Now, the data you paste will not be reformatted or even analyzed for you in any way! – DanO – 2014-10-22T22:00:43.287
Have you tried custom formula? – Jeremy John – 2012-11-19T17:35:38.253
Here is a similar question http://stackoverflow.com/q/13082641/1370465
– Jook – 2012-11-19T17:44:57.263@JeremyJohn - custom formula? What do you mean? – Tomas – 2012-11-19T17:53:59.753
but the data you are pasting is not about dates, right? – None – 2012-11-19T17:54:06.200
@BrOSs - exactly – Tomas – 2012-11-19T17:55:40.653
what about a working-aroung? it can be silly but what if you paste it in notepad? – None – 2012-11-19T18:05:01.693
can you show example of data you are inserting into excel? – None – 2012-11-19T18:06:44.250