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 vote
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,
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 vote
This is already supported using the ACE OLEDB driver.
- Don't see your idea?