Excel won't Decrease Decimals?

Question

Hello,

I've got an issue with Excel not decreasing Decimals when the number is generated by a Forumla, I tried " Format Cells" and the Decrease Decimal buttons, it didn't work.

I've got Decimal Numbers @ cell A:   1.13

I've got Decimal Numbers @ cell B: 8.69

I have this code @ cell C: ="U:" & B5*10 & " F:" & 10*B5-10

How it looks:  U:86.9230769....  F: 76.92307692307...

How I'd prefer it to look: U:86.92 F:76.92

It works like that on cells that ends with 0, such as U:93.3 F:83.3  since both ends with a "0" but whenever it's not, it's being so annoying..

Screenshot: http://prntscr.com/f1tk4z

Anyone got a solution to this?

Thanks!

Answer 1

Hi,

It doesn't format the decimals because it's a text string but you can do it like this.

="U:"&TEXT(B5*10,"0.00")&" F:"&TEXT(10*B5-10,"0.00")

Answer 2

THANK YOU VERY MUCH! perfect! :)