When working with data in Excel, you may come across cells containing dashes (-) instead of numbers or text. These dashes can appear for a variety of reasons, including: Data Entry Errors:Dashes may appear in Excel when data is entered incorrectly. For example, if a user accidentally types...
Note that many desktop publishing programs are so advanced that they automatically (and incorrectly) insert “smart” apostrophes and quotation marks in all of these situations. This can be changed in the program’s settings, but the quickest way around this is simply to copy and paste the corr...