3 ms·
I don’t know if you’re aware of it, but if you want unaltered text content in an Excel cell, prefix it with a single quote ('). This “escapes” the value so that
by layer8 4y ago
I don’t know if you’re aware of it, but if you want unaltered text content in an Excel cell, prefix it with a single quote ('). This “escapes” the value so that it isn’t interpreted as any other data type.
- slotrans 4y agoI'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.