| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text formating
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Brad" wrote in message ... 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? |
|
#4
|
|||
|
|||
|
That did it - thanks!
"bj" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating text in cells | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Conditional Formating when result is text | Excel Worksheet Functions | |||
| Formating a text string? | Excel Discussion (Misc queries) | |||
| formating text cells | Excel Discussion (Misc queries) | |||
Linear Mode
