Forum Discussion
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.
what happens if you select the cell, press F2 and then immediately press Tab or Enter?
- 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.
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.
