Thread: Concatenating %
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
confused confused is offline
external usenet poster
 
Posts: 193
Default Concatenating %

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.