Rounding while still seeing ".0"

[sassriverrat]

Good Morning,

I'm trying to use a simple rounding formula but I don't want to lose the ".0" when a number, say 14.96, is rounded up to 15. I cannot format the cell itself. Ideas on how to do this. It's probably super simple but I've been brain farting all afternoon/evening....

 

[jasonb75]

Re: Rounding, having the decimal place with seeing the decimal point

Modifying the existing suggestions to remove the decimal. Assumed no negative values.

="F/"&TEXT(ROUND(A1*10,0),"0")&"//"

="F/"&TEXT(ROUND(A1,1)*10,"0")&"//"

="F/"&TEXT(A1*10,"0")&"//"

=TEXT(A1*10,"F\/0\/\/")

There are probably other ways to achieve the same result.

 

[sassriverrat]

Re: Rounding, having the decimal place with seeing the decimal point

And what do you get, instead?

Huh....so it was still producing a decimal. I closed the workbook and reopened it and now it seems to be working. Not sure why that happened but thank you!

 

[Anthony47]

Re: Rounding, having the decimal place with seeing the decimal point

="F/"&TEXT(ROUND(A1*10,0),"0")&"//"

Using ROUND(A1*10,1) or ROUND(A1*10,0) doesn't make any difference because the text formatting; but I agree that ",0" is neater. I like your customized format.

Bye