I have a column where the cell's numerical value progresses by .01 and
is formatted to two decimal places. I am adding that cell's value to
the adjacent cell combined with a string [="Text"& B1] but values of
..10, .20, .30 etc. are dropping the trailing 0 giving me .1, .2 etc.
How do I fix this formatting?

Thanks for any help.