Enter numbers in cells

Copper Contributor

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