Ladies and Gentleman,
I have tried to serach this forum but could not find what I need. I have bunch of 22 digits numbers, e.g. 9612019086568871420292. When I copy them into Excel cells they become like 9.61202E+21. And, this is the problem. I would like to see them as 9612019086568871420292. I have tried all possible way to format as General, Numbers, Texts, etc but none worked. Also did Paste Special>Value, etc. none worked. Any suggestion? Thank you in advance.
I have tried to serach this forum but could not find what I need. I have bunch of 22 digits numbers, e.g. 9612019086568871420292. When I copy them into Excel cells they become like 9.61202E+21. And, this is the problem. I would like to see them as 9612019086568871420292. I have tried all possible way to format as General, Numbers, Texts, etc but none worked. Also did Paste Special>Value, etc. none worked. Any suggestion? Thank you in advance.