Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.
To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Be able to turn off auto-conversion of fractions and words into dates
When I import data in the format of a fraction #/#, excel automatically converts this into a date. This is unnecessary and should not be a default operation. At least, there should be a simple way to undo this.
I work with biological data, and there are gene names like "Oct1", and these get converted into dates, causing errors in data analysis.
1 voteHi,
You can do this already in Excel today – there are two ways:1. You can type an apostrophe before the data you enter → ’Oct1, and Excel will then not interpret that as a date (it will interpret it as Text).
2. If you format the cell as Text before typing the value in the cell, Excel will not interpret it as a date.
Hope that helps,
Dan [MS] -
SQL query tools integration
Ability to run SQL queries, being able to select / union select from multiple worksheets
Using the same SQL tool, updated / insert records in other worksheets ( tabs)
1 voteHi,
This is already supported using the ACE OLEDB driver.
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Cheers,
Dan [MS]
- Don't see your idea?