Thread: Concatenating %
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default Concatenating %

Confused wrote:
I have two cells, showing a value of 5.25% and 6.75%.
I need it to show 5.25%/6.75%.
The problem is, the numbers will change.
If I use the concatenate function, it comes out as 0.528/0.0675.
I need to show as a percent.


Does the following do it for you?

=text(5.25/100,"0.00%") & "/" & text(6.75/100,"0.00%")

Of course, 5.25/100 and 6.75/100 can be replaced by any numerical
expression.