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...
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.