column width changes

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I have two seperate workbooks (Excel 2000)with exact same
formatting. I save them as Excel 97 formats for use by
colleague with older version of Excel. One workbook is
okay but other will have one column width reduced, which
causes cell to display ####. I've compared the workbooks
one for one and cannot locate the problem. Any help?
 
The first question I have is what's in that cell? Is it a date?

Excel picks up several date formats from windows regional settings. For
example, if you format as m/d/y and I use mm/dd/yyyy as my windows (8 digits and
2 slashes). If you use m/d/yy, it could be 4 digits and a pair of slashes.

Since I use the longer data format, I don't usually do anything special (a
little wider column doesn't hurt the recipients much). But maybe you could just
widen the column a bit and see if that helps.

If it isn't a date, then there have been some posts that say that in some
versions of xl97, the columnwidths don't get remembered--but I don't recall any
that mentioned xl2k at all).
 
Back
Top