Adding text to a cell using a custom format instead of typing it clearly labels the data and still lets Excel calculate it. (Click for larger image).

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.