CODEWITHSUNDEEP
excelexcel-formuladecimal
Vince Osana
Vince Osana

Reputation: 417

Excel formula, always include 2 decimal value on right

I am concatenating multiple cells together which the values are numbers with 2 decimal places, what I want to happen is to merge all the values but has the fix output like If the amount is 100 --> becomes 100.00 then 10000 in the output file. If the amount is 99.50 --> It can be inputted as 99.50 and 9950 in the output file.

please see image below for reference.enter image description here

Upvotes: 0

Views: 490

Answers (2)

Profex
Profex

Reputation: 1390

Your lucky I have to go leave...

=C2*100&D2*100

worst case, you might want to use Trunc() to be 100% that you didn't have a 3rd decimal place somewhere

=TRUNC(C2*100,0)&TRUNC(D2*100,0)

Upvotes: 0

user4039065
user4039065

Reputation:

Try,

=substitute(text(c2, "0.00"), ".", "")&substitute(text(d2, "0.00"), ".", "")

Upvotes: 2

Related Questions