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.
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.
Thanks. The values in D3:D5 are left-aligned, a tell-tale sign that Excel treats them as text.
I notice that the values contain a point (dot). If your computer uses comma as decimal separator, Excel won't recognize the points. So select D3:D5 and replace point with comma. Does that make a difference?
- Nooooo Way! No way....No FKN way.....unbelievable!
Thanks Buddy....That solved the problem.
