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.
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.
Thanks Buddy....That solved the problem.