You can format the cell to shrink the font so the text fits.

Format|cells|alignment tab|check "shrink to fit"

(or just use the largest font that fits with the longest date.)

No Spam Please wrote:

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.

--

Dave Peterson