Forum Discussion

Megabouw's avatar
Megabouw
Copper Contributor
Apr 21, 2022

Cell Format to Currency not working

After I convert a cell to a currency format, the currency symbol does not show. Even when I convert it using the custom format, it does not show.

Excel
    • Megabouw's avatar
      Megabouw
      Copper Contributor
      Apr 21, 2022
      Absolutely nothing. It remains the same. One other issue I have noticed (Not sure if it is related) When I enter a simple formula like =SUM(CELL1:CELL2) it gives an error regardless if all the cells are formatted the same numeric format.
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Apr 21, 2022

        Megabouw 

        Could you upload a sample workbook without sensitive data to a cloud service such as OneDrive, Google Drive, Dropbox or similar. Obtain a link to the uploaded file and post the link in a reply.

  • Roger1095's avatar
    Roger1095
    Copper Contributor
    Jan 06, 2023

    Megabouw 

    In the "Format Cells" window, after you select the "Currency" category, you will see an option to also select a "Symbol" for the currency type (located directly below the "Decimal Places" box). Simply use the drop-down cursor and select the $ symbol. 

Share

Resources