• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

Column Width keeps changing

I have excel files that keeps changing the column width.  When I make the change (open the columns) and then save the file, I reopen the file and it still show the column width too small.

Do anybody know why this is happening?
0
vhooper780
Asked:
vhooper780
  • 3
1 Solution
 
DreamboatCommented:
On what type of field?

If the date fields are formatted as 00/00/00, and your PC (regional settings) is set to show 00/00/0000, this could cause this problem, I think.

Look in the folder on your PC called XLSTART. Is there anything in there? Close Excel, remove any files from XLSTART and launch Excel again, open the file. Same problem?

Tools-Options-General tab contains an alternate startup directory. If there's anything in there, remove it for now. Close and reopen Excel and then the file. Does that help?
0
 
DreamboatCommented:
Oops. If it's a date field problem that is happening, select the column, hit Format-Cells and set the date format to 00/00/0000 IN THE EXCEL FILE TOO.
0
 
vhooper780Author Commented:
Thanks, it worked.
0
 
DreamboatCommented:
Terrific!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now