Forum Discussion
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 tried clearing formats and re‑applying currency, but the issue remains. There are no warning symbols.
Please advise how to fix this. Thanks.
2 Replies
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.
You don't give enough information for a definitive answer. For example, on the most basic level you don't say how the cost figures are entered into that column:
- are they the result of a calculation?
- do you simply type them in?
- are the the result of a copy and paste from some other electronic/computer source such as an emailed invoice?
- something else?
I could hazard the guess that what's being entered--by whatever method that's being done--is coming in as text, in which case the currency formatting would not apply. But that's a guess.
