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
wrote in message
oups.com...
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.