Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting range in concatanate
Hi,
I have a problem in a concatanating formula. my text is pretty simple, with this, i have added a value from a cell. This is a percentage figure (25%). Only, it looks like this 25.04568472367376574%. I have formatted the cell to 1 decimal point but can this be done for the concatanating formula? Regards, Nigel |
#2
|
|||
|
|||
=TEXT(A1,"0.0%")&... the rest
-- HTH RP (remove nothere from the email address if mailing direct) "Nigel" wrote in message ... Hi, I have a problem in a concatanating formula. my text is pretty simple, with this, i have added a value from a cell. This is a percentage figure (25%). Only, it looks like this 25.04568472367376574%. I have formatted the cell to 1 decimal point but can this be done for the concatanating formula? Regards, Nigel |
#3
|
|||
|
|||
Hi,
That doesnt seem to work. even if i start with =text. here is my actual formula. =CONCATENATE(A5 & " are responsible for £" &D5 & " of this years current work in progress.( "&F5&"% )") A5 = Client Name D5 = Cost to Date F5 = Percentage. currently showing 0.11191432234085% ( ineed this to show 11.19%) Regs, Nigel "Bob Phillips" wrote: =TEXT(A1,"0.0%")&... the rest -- HTH RP (remove nothere from the email address if mailing direct) "Nigel" wrote in message ... Hi, I have a problem in a concatanating formula. my text is pretty simple, with this, i have added a value from a cell. This is a percentage figure (25%). Only, it looks like this 25.04568472367376574%. I have formatted the cell to 1 decimal point but can this be done for the concatanating formula? Regards, Nigel |
#4
|
|||
|
|||
You don't need CONCATENATE and &
=A5&" are responsible for £"&D5&" of this years current work in progress.("&TEXT(F5,"0.0%"&" )") -- HTH RP (remove nothere from the email address if mailing direct) "Nigel" wrote in message ... Hi, That doesnt seem to work. even if i start with =text. here is my actual formula. =CONCATENATE(A5 & " are responsible for £" &D5 & " of this years current work in progress.( "&F5&"% )") A5 = Client Name D5 = Cost to Date F5 = Percentage. currently showing 0.11191432234085% ( ineed this to show 11.19%) Regs, Nigel "Bob Phillips" wrote: =TEXT(A1,"0.0%")&... the rest -- HTH RP (remove nothere from the email address if mailing direct) "Nigel" wrote in message ... Hi, I have a problem in a concatanating formula. my text is pretty simple, with this, i have added a value from a cell. This is a percentage figure (25%). Only, it looks like this 25.04568472367376574%. I have formatted the cell to 1 decimal point but can this be done for the concatanating formula? Regards, Nigel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Automatic formatting of minimum/maximum value in a range. | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions | |||
HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE | Excel Worksheet Functions |