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

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


Gary


"cherman" <(E-Mail Removed)> wrote in message
news:A1B2B978-6966-45AE-8147-(E-Mail Removed)...
>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

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

Alternatively wrap the text.

N10

"cherman" <(E-Mail Removed)> wrote in message
news:A1B2B978-6966-45AE-8147-(E-Mail Removed)...
>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