Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why can't I type in a date?
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Rats. Thanks for the reply, though.
"Frank Kabel" wrote: 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. |
#4
|
|||
|
|||
The only option may be to combine the cell with the cell to its right, if
it's available. You can either merge the two cells or use the "center across selection" option (both in cell formatting). You may have to monkey with the justification options though. "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. |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |