Today's blog post on repairing numbers that are formatted as text is brought to you by Gary Willoughby, who writes Help content for Microsoft Excel. A few months ago, my new manager e-mailed us (that is, her team of Excel writers). She had a spreadsheet with some columns of numbers that she wanted to total, and the answer was resolving to 0. When you have lots of values in a column and their total is 0, you have a problem: Those numbers may not be numbers at all ! (cue the scary music). Keep
Read More...
Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2011/01/04/repairing-numbers-formatted-as-text.aspx
Posted
Jan 04 2011, 06:00 PM
by
Microsoft Excel