I want excel don't auto change my num.

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3134905%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bzh-CN%5C%26quot%3B%22%3EI%20want%20excel%20don't%20auto%20change%20my%20num.%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3134905%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bzh-CN%5C%26quot%3B%22%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346120iF6CA2AF2AE2362C4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22wonder_max_0-1644302564117.png%22%20alt%3D%22%5C%26quot%3Bwonder_max_0-1644302564117.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20want%20excel%20don't%20auto%20change%20my%20num.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ewhat%26nbsp%3Bcan%26nbsp%3BI%26nbsp%3Bdo%EF%BC%9F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3134905%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bzh-CN%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

wonder_max_0-1644302564117.png

I want excel don't auto change my num.

what can I do?

2 Replies
Hi
Change the column format to number, that way excel will keep the number format as it is since it is not exceeding 15 digits.
Highlight the column --> Ctrl+1 --> from the number tab, on the left side select number --> OK
Thank you. This method is OK
I want excel not to automatically convert into scientific counting method when I input long numbers. I want to display the numbers completely. I hope excel will not process them automatically. Don't change my numbers