Apr 21 2022 12:59 AM
Apr 21 2022 01:48 AM
Apr 21 2022 06:00 AM
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?
Jan 05 2023 07:29 PM
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.