Thread: Text formating
View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

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.

"Brad" wrote:


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?