Hi
no way around this. As a date is a numeric value Excel just can't write
it over the cell border!

--
Regards
Frank Kabel
Frankfurt, Germany

"No Spam Please" schrieb im Newsbeitrag
...
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.