Forum Discussion
MartaG
Mar 27, 2026Copper Contributor
Excel-Formating Issue
Hi, I am working on a simple Excel spreadsheet with medical costs. Some numbers show US dollar currency ($) and some do not, even though I applied currency formatting to the entire column. I have...
SergeiBaklan
Mar 30, 2026Diamond Contributor
If you apply currency or any other related to numbers format and nothing happens, most probably you have text value in the cell which only looks like number. You may check with ISTEXT() function.