paste as text
excel is missing one important function: PASTE AS TEXT...
for various reasons pasting with excel intelligent guessing the type of data in the pasted cells do not work well, although there is no error in that (doing unexpected conversions of pasted data)...
what I need is the functionality to say to excel: paste all data as text into appropriate cells (and I will later edit it and correct and convert data)
also, convert-text-to-columns should have that functionality... yes, I am aware that I can use that functionality at the column level, but I would also like to be able to say it at once, for all the columns (for there are a lot of columns and I am not aware of where the problems with data really are before I see the data pasted...
so, let mi first put data in the cells as text and I will later handle what is to be handled...
this is a hugely missing functionality in excel, thanks :-)
This is already supported, if I understand what you’re looking for. Look for Paste Special > Values (if you copied from Excel) or Paste as Text (if you copied from another app).
Thanks for the additional information Gjuro.
I think what you're looking for is captured pretty well in this idea - it'd be great if you could vote on them:
Maintain leading 0's: https://excel.uservoice.com/forums/304921/suggestions/10551039
Stop Excel from changing large "numbers" (actually text values) to scientific notation) - https://excel.uservoice.com/forums/304921/suggestions/10374741
Gjuro Kladaric commented
of course, THIRD column in the below report is completely unimportant, it can be any column
I just had such a sample and had not refined that idea and corrected my report
pardon me :-)
Gjuro Kladaric commented
oh, it does not really work... try this: have a text file with three columns of comma separated values
make the last column be all digits, some kind of personal number, and let some of them have leading zeroes
let .csv file have TABs as column separator (so lines will be automatically broken into columns and populated in three columns)
and when you say: PASTE AS TEXT, what will be the outcome? you will get numbers in the third column AND YOU WILL LOSE THOSE LEADING ZEROS, for PASTE AS TEXT puts its data into cells that are formatted as GENERAL, and not as TEXT
that is true even if data do not contain column separators... you get a column of GENERALly formatted cells (with all kind of problems as excel tries to be usefull servant and guess how to use pasted data)
so, let PASTE AS TEXT mean PASTE AS TEXT TO TEXT CELLS