4 ms·
I'm generally pasting the results of a SQL query so this is, while possible, massively annoying to do
by slotrans 4y ago
I'm generally pasting the results of a SQL query so this is, while possible, massively annoying to do
- layer8 4y agoIn that case, you could prepare a sheet in advance by setting the format of all cells to text. Shortcut sequence Ctrl+A Ctrl+1 Tab T T Return. You can record this as a macro (Developer tab) or save the result as a template. Yes, the default format behavior can be annoying, but if it's a frequent problem there are ways to make one's life easier.
- zokier 4y agoExcel has "paste with text import wizard" functionality where you can explicitly define the types your columns. For even more control try powerquery.