Column size issue
 

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

Column size issue
 

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


Gary


"cherman" wrote in message
...
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

Column size issue
 

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

Alternatively wrap the text.

N10

"cherman" wrote in message
...
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