Need help with Excel entries

%3CLINGO-SUB%20id%3D%22lingo-sub-2530697%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20Excel%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2530697%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20trying%20to%20come%20up%20with%20a%20quicker%20way%20to%20enter%20time%20in%20my%20workbooks%20than%20typing%20in%2000%3A00.%20I%20have%20decided%20that%20I%20can%20just%20use%20general%20and%20let%20the%20program%20enter%20a%20decimal%20point.%20The%20problem%20is%20that%20when%20I%20enter%202240%2C%20I%20don't%20get%2022.40%2C%20I%20get%2022.4.%20Is%20there%20anyway%20to%20force%20this%20to%20enter%20all%20of%20the%20numbers%20that%20I%20type%3F%3C%2FP%3E%3CP%3ESincerely%2C%3C%2FP%3E%3CP%3EMonte%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2530697%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2530961%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Excel%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2530961%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1099127%22%20target%3D%22_blank%22%3E%40Monte_Salyards%3C%2FA%3E%26nbsp%3BWell%2C%20the%20last%20thing%20to%20do%20would%20be%20to%20format%20the%20cells%20with%20these%20%22time%20entries%22%20to%20be%20displayed%20with%20two%20decimals.%20(Ctrl-1%2C%20Number%2C%20Decimal%20places%2C%202).%20Or%20on%20the%20home%20ribbon%2C%20look%20for%20and%20press%20the%20icon%20%26nbsp%3B%3CSTRONG%3EIncrease%20Decimals%3C%2FSTRONG%3E%20in%20the%20Number%20group.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-07-09%20at%2006.37.44.png%22%20style%3D%22width%3A%20236px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294541i238643EF8D489131%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-07-09%20at%2006.37.44.png%22%20alt%3D%22Screenshot%202021-07-09%20at%2006.37.44.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2532280%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Excel%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2532280%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%3CP%3EThe%20standard%20format%20for%20numbers%20is%20two%20decimals.%20I%20can%20change%20that%20in%20advanced%20options%2C%20but%20the%20problem%20is%20that%20when%20I%20enter%2022.40%2C%20the%20entry%20shows%20as%2022.4.%20If%20I%20were%20to%20enter%2022.41%2C%20then%20the%20entry%20would%20show%20as%2022.41.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have been trying to come up with a quicker way to enter time in my workbooks than typing in 00:00. I have decided that I can just use general and let the program enter a decimal point. The problem is that when I enter 2240, I don't get 22.40, I get 22.4. Is there anyway to force this to enter all of the numbers that I type?

Sincerely,

Monte

3 Replies

@Monte_Salyards Well, the last thing to do would be to format the cells with these "time entries" to be displayed with two decimals. (Ctrl-1, Number, Decimal places, 2). Or on the home ribbon, look for and press the icon  Increase Decimals in the Number group.

Screenshot 2021-07-09 at 06.37.44.png

@Riny_van_Eekelen 

The standard format for numbers is two decimals. I can change that in advanced options, but the problem is that when I enter 22.40, the entry shows as 22.4. If I were to enter 22.41, then the entry would show as 22.41.

@Monte_Salyards If you first format the range where you want to put the time entires as a number with two decimals and set Excel to automatically display two decimal places, entering 2240 shall return 22.40.

Likewise 1000 will return 10.00