View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
deepc deepc is offline
external usenet poster
 
Posts: 1
Default How do I format Concatenate function?

My goal is to combine 2 values that are calculated in their respective cells
into one string.
What I have is the number '2' in cell A1 and the number '3 1/8' in cell B1.
I want to come up with the text 2'-3 1/8" in cell C1. My problem is that the
inches part of it comes out in decimals, not as a fraction, ie. I get
2'-3.0625" instead. What is the easiest way to solve this? I've got thousands
of cells to convert.