If your data set contains values into the trillions or less than a thousand, create new custom formats for those positions and apply them using conditional formatting. Excel can handle them all.

Data tables are presented in Microsoft Excel format.The data is presented in columnar format.Calculations and Formatting can be done on the data. To Save a Excel File to Disk To save a Excel file to ...