Mar 08 2021 01:13 AM
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
Mar 08 2021 01:26 AM
SolutionClick 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)
Mar 08 2021 02:18 AM
May 24 2021 07:48 AM
@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:30 | 20:00 | 08:00 | 17:00 | 08:00 |
08:30 | 08:30 | 20:30 | 20:30 | 00:00 |
1,50 | 1,50 | 1,50 | 1,50 | 1,50 |
22,50 | 11,00 | 11,00 | 26,00 | 38,50 |
May 24 2021 11:07 AM
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)
Mar 08 2021 01:26 AM
SolutionClick 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)