Concatenate 2 numbers and keep a "000000.00" format

Hello all,

I would like to join or concatenate 2 numbers and keep a 000000.00 format. I am not sure what kinds of formula or cell formatting I need to use. Here is a picture of what I expect to do.Screenshot 2021-04-30 103905.jpg

Column 1's numbers will have a minimum of 1 number and a max of 6. Column 2 will always have a 2 number format (0's are part of the number).

Can someone help me out with a formula that can combine Column 1 and Column 2's numbers so they show like the numbers in the 'Result I expect' column?

Thanks!

Why concatenate?

Try this:

=A2+IFERROR(B2/100,0)

What he said!

Thanks for the rep.