Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Column Width keeps changing

Posted on 2001-06-19
4
Medium Priority
?
198 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 200 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

886 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