Default decimal places

%3CLINGO-SUB%20id%3D%22lingo-sub-3445538%22%20slang%3D%22en-US%22%3EDefault%20decimal%20places%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3445538%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Microsoft%20Excel%20on%20a%20Mac%20M1.%3C%2FP%3E%3CP%3EEver%20since%20I%20started%20using%20it%203%20months%20ago%2C%20whenever%20I%20input%20any%20number%20into%20a%20cell%2C%20it%20%22misplaces%22%20the%20decimal%20point.%3C%2FP%3E%3CP%3Eie....%20if%20I%20want%20too%20input%20the%20whole%20number%20100%20-%20it%20shows%20as%201.00%3B%20(If%20I%20want%20to%20use%20the%20whole%20number%20100%20in%20a%20cell%2C%20I%20have%20to%20enter%3A%20100%3CSTRONG%3E.%3C%2FSTRONG%3E%20-%20with%20the%20decimal%20point%20physically%20entered%20at%20the%20end%20of%20the%20number)%3C%2FP%3E%3CP%3Eif%20I%20want%20to%20input%20the%20whole%20number%202450%20-%20it%20show%20as%2024.50.%26nbsp%3B(If%20I%20want%20to%20use%20the%20whole%20number%202450%20in%20a%20cell%2C%20I%20have%20to%20enter%3A%202450%3CSTRONG%3E.%3C%2FSTRONG%3E%20-%20with%20the%20decimal%20point%20physically%20entered%20at%20the%20end%20of%20the%20number)%3C%2FP%3E%3CP%3EThe%20decimal%20place%20defaults%20to%20two%20places%2C%20no%20matter%20what%20number%20I%20input.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20can%20I%20change%20this%20on%20Microsoft%20Excel%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3445538%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3445801%22%20slang%3D%22en-US%22%3ERe%3A%20Default%20decimal%20places%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3445801%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1407387%22%20target%3D%22_blank%22%3E%40Stewart90%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20the%20Excel%20menu%2C%20select%20Preferences...%3C%2FP%3E%0A%3CP%3EClick%20Edit.%3C%2FP%3E%0A%3CP%3EClear%20the%20check%20box%20%22Display%20this%20number%20of%20decimal%20places%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3445983%22%20slang%3D%22en-US%22%3ERe%3A%20Default%20decimal%20places%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3445983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1407387%22%20target%3D%22_blank%22%3E%40Stewart90%3C%2FA%3E%26nbsp%3BThe%20setting%20is%20where%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3Bpointed%20you%20to.%20However%2C%20on%20my%20Excel%20for%20Mac%20(MS365)%20the%20setting%20that%20you%20need%20to%20uncheck%20is%20called%20%22%3CEM%3EAutomatically%20insert%20a%20decimal%20point%20(places)%3A%3C%2FEM%3E%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-05-30%20at%2017.20.40.png%22%20style%3D%22width%3A%20337px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-05-30%20at%2017.20.40.png%22%20style%3D%22width%3A%20337px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-05-30%20at%2017.20.40.png%22%20style%3D%22width%3A%20337px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-05-30%20at%2017.20.40.png%22%20style%3D%22width%3A%20337px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202022-05-30%20at%2017.20.40.png%22%20style%3D%22width%3A%20337px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F376152iBD7C441528C30FBE%2Fimage-dimensions%2F337x224%3Fv%3Dv2%22%20width%3D%22337%22%20height%3D%22224%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-05-30%20at%2017.20.40.png%22%20alt%3D%22Screenshot%202022-05-30%20at%2017.20.40.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3446019%22%20slang%3D%22en-US%22%3ERe%3A%20Default%20decimal%20places%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3446019%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%20Riny%20-%20I%20don't%20have%20a%20Mac%20myself.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3446036%22%20slang%3D%22en-US%22%3ERe%3A%20Default%20decimal%20places%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3446036%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BI%20know%20%3A))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am using Microsoft Excel on a Mac M1.

Ever since I started using it 3 months ago, whenever I input any number into a cell, it "misplaces" the decimal point.

ie.... if I want too input the whole number 100 - it shows as 1.00; (If I want to use the whole number 100 in a cell, I have to enter: 100. - with the decimal point physically entered at the end of the number)

if I want to input the whole number 2450 - it show as 24.50. (If I want to use the whole number 2450 in a cell, I have to enter: 2450. - with the decimal point physically entered at the end of the number)

The decimal place defaults to two places, no matter what number I input.

 

Where can I change this on Microsoft Excel??

4 Replies

@Stewart90 

On the Excel menu, select Preferences...

Click Edit.

Clear the check box "Display this number of decimal places".

@Stewart90 The setting is where @Hans Vogelaar pointed you to. However, on my Excel for Mac (MS365) the setting that you need to uncheck is called "Automatically insert a decimal point (places):"

 

Screenshot 2022-05-30 at 17.20.40.png

@Riny_van_Eekelen 

Thanks, Riny - I don't have a Mac myself.

@Hans Vogelaar I know :))