Enter numbers in cells

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3156733%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EEnter%20numbers%20in%20cells%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3156733%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20entered%20the%20number%206500%20in%20the%20cell%20and%20hit%20enter%20and%20the%20number%20became%2065.00.%20How%20do%20I%20change%20the%20default%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3156733%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%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
Occasional Visitor

I entered the number 6500 in the cell and hit enter and the number became 65.00. How do I change the default?

2 Replies

@george1450 

 

goto 
home > number>in dropdown choose last number format>at left side in the list choose number> place decimal place 0

harshulz_0-1644631590944.png

 

@george1450 

 

File/Options/Advances - see if "Automatically insert a decimal point" is checked.

 

JMB17_0-1644633494019.png