SOLVED

New Contributor

# Comma function

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

# Betreff: Comma function

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.

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)

# Betreff: Comma function

Thank you! Looks so simple but correct

# Betreff: Comma function

Thank you for letting me help.
In the simplicity is complexity.

You are welcome

# Betreff: Comma function

@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

# Betreff: Comma function

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)