Hello,I'm Excel stupid. I have an Excel speadsheet with an entire column of numbers represetning dates. The numbers are in the format ddmmyyyy, so an example of a number would be 12022003. I would ...

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.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.