Formatting combined Cells

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.

Hi

use
="Text "& Text(B1,".00")

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
<[email protected]> wrote in message
news:[email protected]...
>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.
>