Text formating

B

Brad

What I want the line to read
Current (Non-Guaranteed) interest rate: 5.00% in year one, 3.00% in years
thereafter.

What the line is currently reading
Current (Non-Guaranteed) interest rate: 5% in year one, 3% in years
thereafter.

Where the two interest rates are concatenated in a string. How can I make
sure that I always have two decimal points shown?
 
B

bj

try
="Current (Non-Guaranteed) interest rate: " & text(0.05,"0.00%") & " in year
one, " & text(A2,"0.00%") & " in years thereafter"

if the 5 is always constant and the .03 value is in cell A2 or you could
make both references or constants.
 
E

Earl Kiosterud

Give us the formula in the cell (that's doing the concatenating). I suspect
you need to use the TEXT function, if you have cell references to the
interest rates. But I don't guess any more. Tell.
 
B

Brad

That did it - thanks!

bj said:
try
="Current (Non-Guaranteed) interest rate: " & text(0.05,"0.00%") & " in year
one, " & text(A2,"0.00%") & " in years thereafter"

if the 5 is always constant and the .03 value is in cell A2 or you could
make both references or constants.
Click to expand...
 
Top