Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Klaus & Gale Waibel
 
Posts: n/a
Default Bizarre Behavior in Excel

Often now when I open an Excel 98 for MAC spreadsheet my date fields all
display #####. I know it is supposed to be the indication that the column
is too small. However, in the formula bar the contents are now shown as the
old Lotus timeline value, e.g. 35237.

When I attempt to format the cell using the Format/Cells/Date format it has
no effect. If I try to enter a new date such as 1/5/05 (even in new cells),
Excel does not automatically recognize it, and instead just treats it like a
text string.

Also, another thing that happens is that my spreadsheets will open with a
number of initial columns hidden. I can use the Format/Columns/Unhide
command to get them back, with of course now all of the date fields looking
like ####.

I have noticed that if I launch Excel 98 and use the Open/File command, I
often get this "corrupted" spreadsheet. But if I start with double-clicking
on the Excel file to launch the document and therefore the application, I'm
OK.

I have tried re-installing Excel, but it has not helped. I thought I might
have a virus, but a colleague assured me the behavior was not virus-like.

I didn't use to have this problem. It just "evolved" over the last month or
so.

Klaus Waibel
Prince George's County Public Schools
Maryland

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 12:46 PM
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 04:18 PM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 04:49 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:47 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:45 AM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"