On Feb 8, 8:04 am, Dave Peterson wrote:
Another question...

Any chance that these #### cells contain dates.

If yes, then the format of the field could be causing trouble. If the date cell
is formatted to show the short date (m/d/yy), then excel will use the windows
regional setting to display that field.

If the person who created the file had a windows short date format of m/d/yy
(like 8/7/07 (no leading 0's or centuries)), and the person who opened the file
had a windows short date of mm/dd/yyyy (08/07/2007), then the person who opened
the file would see ###'s.

CAPTGNVR wrote:

DEAR ALL

In some of the computers, the excel97 files when u close and open the
columns width gets decreased in such a manner the sums in the columns
will not be seen as it will show ######. What could be the reason
for these columns to decrease in width. Pls adv.

--

Dave Peterson

D/DAVE N MIKE
Thanks for the input. It was happening in one ship excel97. Luckily
on this ship it is not happening. Like i said it was decreasing by
itself on the same comp and there was no date. Only the usual sum of
totals etc. But it can be easily seen that a column width of 12 has
been reduced to 5 or there about.. So i wanted to find out the reason
as that fear is there that once i program then the columns will
decrease. anyhow as a safe precaution i hv given a command button to
reset columns and written the vb code.