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.