Share via

Removing a dollar sign from cell with Excel for Mac

Anonymous
Apr 1, 2021, 7:22 PM

I have tried numerous strings to get a dollar sign removed from a cell but somehow can't manage to do so.

The cell has the following content (which includes a dollar sign right in front of the amount):

=(Sheetname!E14)

Tried (among other things)

=LEFT(Sheetname!E14) -1

And multiple variations of that.

Is there somebody who can help me with this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 (2) 7,050 Reputation points Volunteer Moderator
    Apr 1, 2021, 7:55 PM

    Hi PHdJ

    Here is the formula you need:

    =RIGHT (Sheetname!E14, LEN(Sheetname!E14)-1)

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    Apr 1, 2021, 8:02 PM

    Hi,

    I'm Gustavo, an independent advisor. I'll be glad to help you.

    It looks like your cell is formatted as "currency" or "accounting". Did you try to change the cell formatting?

    Best regards.
    Image

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    Apr 1, 2021, 8:21 PM

    Thanks Gustavo, yes I have set 'Finance' there now.

    But I still cannot set the cell's characteristics so the $ sign will not show.

    0 comments
  4. Jim G 133.8K Reputation points MVP Volunteer Moderator
    Apr 7, 2021, 9:40 PM

    Change the setting to Number. Use the buttons to increase or decrease the number of decimal places to display

    1 person found this answer helpful.
    0 comments
  5. Bob Jones AKA CyberTaz 425.1K Reputation points
    Apr 8, 2021, 2:26 PM

    Any of the default Accounting or Currency cell formats will include a currency symbol. Typically any characters added as the result of formatting cannot be removed or altered by formulas because they imposed by a mask... they are not literal content of the cell.

    As Jim suggested, you can change the cell format to Number which does not include a currency symbol.

    If you prefer to use either Currency or Accounting [which I believe is what your installation refers to as Finance], another option is to select the cell, go to Format> Cells - Number then open the Symbol list for that type of formatting & select None. This allows retaining all other aspects of the formatting style including the 2 decimal place accuracy.

    0 comments