Solved

Column Width keeps changing

Posted on 2001-06-19
4
184 Views
Last Modified: 2008-03-06
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
Comment
Question by:vhooper780
  • 3
4 Comments
 
LVL 22

Accepted Solution

by:
Dreamboat earned 50 total points
ID: 6208830
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
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6208833
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
 

Author Comment

by:vhooper780
ID: 6212042
Thanks, it worked.
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6212434
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question