View Single Post
  #4   Report Post  
GerryK
 
Posts: n/a
Default

="$ "&TEXT(A1,"0")&" - $ "&TEXT(B1,"0")
If in A1 is 60 and in B1 is 70 then in C1 put:
HTH

-----Original Message-----
HOW DO I CREATE MULTIPLE CURRRENCY NUMBERS IN ONE CELL.

I.E. $60 - $70
.