I'm constanting working with mixed data...units and dollars. Being able to write the formula such as this would help: =$30,000/20,000...(vs =30000/20000) everytime I try this I get an error. I dont want it to be text. I want to enter into the cell with commas and dollar signs. I used Excel everyday for over 10 years and never thought to do this. Does anyone know how ?