fixed decimal point data entry

%3CLINGO-SUB%20id%3D%22lingo-sub-1433971%22%20slang%3D%22en-US%22%3Efixed%20decimal%20point%20data%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433971%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20switch%20it%20off.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1433971%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433983%22%20slang%3D%22en-US%22%3ERE%3A%20fixed%20decimal%20point%20data%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433983%22%20slang%3D%22en-US%22%3EFile%5COptions%5CAdvanced.%20Uncheck%20%22automatically%20insert%20a%20decimal%20point.%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433989%22%20slang%3D%22en-US%22%3ERE%3A%20fixed%20decimal%20point%20data%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433989%22%20slang%3D%22en-US%22%3EOr%20are%20you%20talking%20about%20the%20cell%20formatted%20to%20show%20decimals%3F%20In%20that%20case%2C%20right%20click%20on%20the%20cell%20and%20select%20Format%20Cells.%20Then%20you%20should%20be%20able%20to%20select%20a%20different%20format%20or%20change%20the%20number%20of%20decimals%20to%20zero.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434014%22%20slang%3D%22en-US%22%3ERE%3A%20fixed%20decimal%20point%20data%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CU%3Ewhere%20do%20I%20find%20%3CSPAN%3EFile%5COptions%5CAdvanced%3F%3C%2FSPAN%3E%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434016%22%20slang%3D%22en-US%22%3ERE%3A%20fixed%20decimal%20point%20data%20entry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434016%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EIf%26nbsp%3BI%20enter%20%221%22%20enter%20key%20it%20shows%20as%20%22.01%22%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I want to switch it off.

4 Replies
Highlighted
File\Options\Advanced. Uncheck "automatically insert a decimal point."
Highlighted
Or are you talking about the cell formatted to show decimals? In that case, right click on the cell and select Format Cells. Then you should be able to select a different format or change the number of decimals to zero.
Highlighted

where do I find File\Options\Advanced?

 

Highlighted

If I enter "1" enter key it shows as ".01"