Something has always bugged me about Excel.

If I type in a date, the width of the cell ALWAYS has to be wide enough to
display the entire date; otherwise, it'll give me the "#####".

If, say, I'm typing in today's date in A1, and there's nothing in B1, why
won't it just bleed the text over to the adjoining cell?

This happens regardless if I'm hardcoding a date, or if I do a formula like
"+today()"

Any way around this? Sometimes, I WANT to keep that particular cell a
certain size.

Thanks.