Date issue to runover into the next blank cell

[Gmick]

Why does't my date run over into the next blank cell?? When I have a
text is runs over the next blank cell, when I have a date in a cell not
big enough??

Any suggestions?

 

[Peo Sjoblom]

Because dates are numbers and they will return #####
if the cell size isn't enough

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Gmick]

Because dates are numbers and they will return #####
if the cell size isn't enough

So there is no option to make this visible?

 

[Jim May]

the option is to make the column "wider".

So there is no option to make this visible?

 

[Peo Sjoblom]

Yes it is, select the cell/column and do format>column>autofit

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Gmick]

Yes it is, select the cell/column and do format>column>autofit

OK, thanks. I understood, it wasn't to option I was looking for.
However, thanks again for the quick responses!

 

[Dave Peterson]

Maybe a smaller font -- or a font that resizes itself.....

Format|Cells|Alignment tab|check the shrink to fit box.