SOLVED

Comma function

%3CLINGO-SUB%20id%3D%22lingo-sub-2192746%22%20slang%3D%22en-US%22%3EComma%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2192746%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day!%3C%2FP%3E%3CP%3EI%20want%20to%20find%20out%20how%20to%20set%20the%20cells%20if%20you%20want%20to%20put%20the%20comma%20in%20excel%20only%20in%20that%20situation%20when%20there%20are%20numbers%20after%20comma.%20For%20example%2C%20if%20answer%20is%207%2C00%20excel%20shows%20you%207%2C%20if%20answer%20is%207%2C50%20-%20excel%20shows%207%2C5%2C%20if%20answer%20is%207%2C75%20-%20excel%20shows%20you%207%2C75.%20Otherwise%2C%20I%20don't%20need%20to%20see%20all%20the%20time%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2192746%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2192761%22%20slang%3D%22de-DE%22%3ESubject%3A%20Comma%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2192761%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F990253%22%20target%3D%22_blank%22%3E%40SigitaMP%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EClick%20on%20cell%20or%20select%20range.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ERight%20mouse%20button%20%22Format%20cells%22%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20%22Format%20Tells%22%20window%20opens%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EGo%20for%20numbers%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ESelect%20the%20%22Standard%22%20category%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EPress%20ok%2C%20done.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditional%20information%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Favailable-number-formats-in-excel-0afe8f52-97db-41f1-b972-4b46e9f1e8d2%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAvailable%20number%20formats%20in%20Excel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20information%20helped%20you%2C%20please%20mark%20this%20post%20as%20%22Correct%20answer%22%20%20and%20click%20on%20like%20(hand%20with%20thumbs%20up)%2C%20so%20that%20other%20members%20can%20benefit%20from%20this%20information%20later.%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2192814%22%20slang%3D%22en-US%22%3EBetreff%3A%20Comma%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2192814%22%20slang%3D%22en-US%22%3EThank%20you!%20Looks%20so%20simple%20but%20correct%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2192868%22%20slang%3D%22de-DE%22%3ESubject%3A%20Comma%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2192868%22%20slang%3D%22de-DE%22%3EThank%20you%20for%20letting%20me%20help.%3CBR%20%2F%3EIn%20the%20simplicity%20is%20complexity.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20You%20are%20welcome%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380910%22%20slang%3D%22en-US%22%3EBetreff%3A%20Comma%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%20hello%2C%20could%20you%20help%20me%20to%20find%20formula%20in%20counting%20working%20hours.%20First%20number%20is%20starting%20time%2C%20second%20finishing%20time%2C%20third%20-%20time%20for%20rest.%20What%20formula%20shoul%20I%20apply%3F%20The%20fourth%20and%20fifth%20ones%20are%20incorrect.%3C%2FP%3E%3CTABLE%20width%3D%22195%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2239%22%3E08%3A30%3C%2FTD%3E%3CTD%20width%3D%2239%22%3E20%3A00%3C%2FTD%3E%3CTD%20width%3D%2239%22%3E08%3A00%3C%2FTD%3E%3CTD%20width%3D%2239%22%3E17%3A00%3C%2FTD%3E%3CTD%20width%3D%2239%22%3E08%3A00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E08%3A30%3C%2FTD%3E%3CTD%3E08%3A30%3C%2FTD%3E%3CTD%3E20%3A30%3C%2FTD%3E%3CTD%3E20%3A30%3C%2FTD%3E%3CTD%3E00%3A00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%2C50%3C%2FTD%3E%3CTD%3E1%2C50%3C%2FTD%3E%3CTD%3E1%2C50%3C%2FTD%3E%3CTD%3E1%2C50%3C%2FTD%3E%3CTD%3E1%2C50%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E22%2C50%3C%2FTD%3E%3CTD%3E11%2C00%3C%2FTD%3E%3CTD%3E11%2C00%3C%2FTD%3E%3CTD%3E26%2C00%3C%2FTD%3E%3CTD%3E38%2C50%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E
New Contributor

Good day!

I want to find out how to set the cells if you want to put the comma in excel only in that situation when there are numbers after comma. For example, if answer is 7,00 excel shows you 7, if answer is 7,50 - excel shows 7,5, if answer is 7,75 - excel shows you 7,75. Otherwise, I don't need to see all the time

5 Replies
best response confirmed by SigitaMP (New Contributor)
Solution

@SigitaMP 

Click on cell or select range.

Right mouse button "Format cells"

The "Format Tells" window opens

Go for numbers

Select the "Standard" category

Press ok, done.

 

Additional Infos:

Available number formats in Excel

 

 

If this information helped you, please mark this post as "Correct answer" and click on like (hand with thumbs up), so that other members can benefit from this information later.

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

Thank you! Looks so simple but correct
Thank you for letting me help.
In the simplicity is complexity.

You are welcome

@NikolinoDE  hello, could you help me to find formula in counting working hours. First number is starting time, second finishing time, third - time for rest. What formula shoul I apply? The fourth and fifth ones are incorrect.

08:3020:0008:0017:0008:00
08:3008:3020:3020:3000:00
1,501,501,501,501,50
22,5011,0011,0026,0038,50

@SigitaMP 

The next time, please start a new request, so that every member can better follow up and look up for a solution.

 

Here is a suggested solution, I have expanded it a bit.

You can set it up as you wish.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)