View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kesbutler Kesbutler is offline
external usenet poster
 
Posts: 30
Default How do I combine dollars and text

I want to combine two different cells that contain dollars and text. when I
try it always drops the $ sign. How do I do this? Example cell A2=$40 and
cell A3 is per year, I want in one cell $40 per year.