Choose Blanks from the dialog and click OK.In the lower-left corner of the Go To dialog, click Special to display the Go To Special dialog.Press Ctrl G to display the Go To dialog.Select the entire range that should contain numeric data.There is an easy way to convert the blanks to zero. If you have a dataset with 50,000 rows of numbers and one blank cell in the middle, the pivot table will count instead of sum. 1: There Are One or More Blank Cells in the ColumnĮxcel expects your numeric data to be 100% numeric.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |