ExcelBanter - Include trailing zeroes in calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Include trailing zeroes in calculation (https://www.excelbanter.com/excel-discussion-misc-queries/268869-include-trailing-zeroes-calculation.html)

AnnieMa

Include trailing zeroes in calculation

I have two columns formatted as numbers with two decimals. I want to concatenate these in a third column, including trailing zeroes.

For instance, if A1=100.10 and B1=110.20 the following calculation =A1&"x"&" "&B1&"y" should result in "110.10x 110.20y", NOT "110.1x 110.2y". I need those missing decimals!

Thank you very much in advance!

All times are GMT +1. The time now is 10:11 PM.