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....

 

[Anthony47]

The formula give you a result (15 for example); the way the result is displayed in the cell depends on the cell formatting.

To se ".0" just select the cell, right click, choose "Cell format"; in the "Number" tab select Number and specify 1 decimal digit; complete with Ok.
If this doesn't do the job, then please specify wich formula you used to round the result.

Bye

 

[sassriverrat]

The formula give you a result (15 for example); the way the result is displayed in the cell depends on the cell formatting.

To se ".0" just select the cell, right click, choose "Cell format"; in the "Number" tab select Number and specify 1 decimal digit; complete with Ok.
If this doesn't do the job, then please specify wich formula you used to round the result.

Bye

Fair enough- here ya go!
A1 is the number to be rounded off.

="F/"&ROUND(A1,1)&"//"

 

[Anthony47]

Fair enough- here ya go!
A1 is the number to be rounded off.

="F/"&ROUND(A1,1)&"//"

Well, your formula returns a "String", not a number; so Formatting will not change the way it is displayed.

Try changing your formula to

="F/"&TEXT(ROUND(A1,1),"0.0")&"//"

Bye

 

[sassriverrat]

Yes. Thank you. That’s why I posted on here trying to figure out how to change this....


Ah yes. Duh. That makes sense. I’ll give it a shot

 

[jasonb75]

You can drop the decimal in the text format, omitting the need for the round function,

="F/"&TEXT(A1,"0.\0")&"//"

Or even shorter

=TEXT(A1,"F\/0.\0\/\/")

You could also use the format in the text function above as a custom format, removing the formula entirely.

 

[sassriverrat]

You can drop the decimal in the text format, omitting the need for the round function,

="F/"&TEXT(A1,"0.\0")&"//"

Or even shorter

=TEXT(A1,"F\/0.\0\/\/")

You could also use the format in the text function above as a custom format, removing the formula entirely.

So I've gone with the formula here but the only issue with it is that I want to remove the physical decimal mark (while keeping the decimal value. So 13.2 would be "132" on here.

Thanks
="F/"&TEXT(ROUND(A1,1),"0.0")&"//"

 

[Anthony47]

So I've gone with the formula here but the only issue with it is that I want to remove the physical decimal mark (while keeping the decimal value. So 13.2 would be "132" on here.

Thanks for beeing a little bit more clear (but you should also modify the title of the discussion)...

With the formula I proposed:

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

Bye

 

[sassriverrat]

Rounding, having the decimal place with seeing the decimal point

Good Morning,

Your first formula (the one with "0.0" was closer than your second proposition, however, I'm looking to have the decimal point disappear without losing the decimal place.

So I never see a whole number as the output without a "0" behind it. Here are a few examples of the desired output:

14.0 = 140
13.9 = 139
12.98 = 130
12.54 = 125

Make sense?

 

[Anthony47]

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

Here are a few examples of the desired output:

14.0 = 140
13.9 = 139
12.98 = 130
12.54 = 125

And what do you get, instead?