currency

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3152562%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3Ecurrency%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3152562%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI'm%20new%20to%20excel%20and%20can't%20get%20numbers%20to%20show%20in%20the%20dollar%20amount.%26nbsp%3B%20It%20just%20keeps%20showing%20as%20a%20number%20and%20then%20it%20wont%20let%20me%20do%20a%20formula%20to%20subtract%20one%20cell%20from%20another.%26nbsp%3B%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3152562%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

I'm new to excel and can't get numbers to show in the dollar amount.  It just keeps showing as a number and then it wont let me do a formula to subtract one cell from another.  

1 Reply

@Dorothy4534 

That makes me think the values are seen as text values by Excel. You can try the following:

  • Select such values in one column.
  • On the Data tab of the ribbon, click Text to Columns, then click Finish without changing any settings.
  • If that helps, repeat for other columns if necessary.