IT Employment

NT

This question should be in Technical Q & A.

This is a tech. problem, in search of a solution.

It properly belongs in "Technical Q&A," not in "Discussions."

Please re-post there.

Thank you.

I have the answer for those of you who hated Excel because of this.

I had the same problem with Excel while I was working on the engineering project.
I had data of 1-0, 2-3, etc. and it would automatically convert them into dates when I tried to download them into excel spreadsheet.

So here is how to fix this problem. (and I'm posting this so that if anyone wants to figure this out, here is the solution)

1)You have data as a web report and want to download that information into excel.
if you right-click on the web page, you will find "Export to Microsoft Excel" click that.

2)You will be redirected to Microsoft Excel and the window "Edit web query" will pop up. click on options on the upper right corner

3)Under "other import settings" click on the "disable date recognition" to stop it from automatically formating your precious data.

This will work if you have a web-paged data that you want to download into excel file.
I haven't thought or looked well into downloading a file and disabling it that way. But if I do figure it out, I'll come back to it.

Thanks all.