Use a custom format in Microsoft Excel to reduce the number of digits in a large number without losing its scale.

Figure A Apply a custom format to display dates in YYYY-MM-DD format. Figure B The custom format at work. However, if you paste a differently formatted date, Excel accepts the source formatting.