Column size issue

[Guest]

I am creating a workbook from Access and dumping data to it. Everything works
fine except for 1 cell, where I drop a date formatted like "June 1, 2007".
The column is not wide enough, so the data show like "####".

I don't want to widen the column because it will push my data into a 2nd
page if the date is too long and I don't want to use shrink to fit. I just
want the data to write to the cell and "write over" the next cell if the data
is wider than the column.

Any suggestions would be greatly appreciated.

Thanks,
Clint

 

[Gary Keramidas]

about the only suggestion i have is to change the font size

 

[N10]

Change the format to dd/mm/yyy ( or mm/dd/yy) .

Alternatively wrap the text.

N10