Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Corrupted Caption for Date in XP and Excel


  • Please log in to reply

#1
urichjones

urichjones

    Member

  • Member
  • PipPip
  • 45 posts
Hello,
First I must say it's been a while since I've posted and I LOVE what you've done with the place. :tazz:

Anyways, I was wondering if anyone has experienced this problem. When I bring my mouse over my taskbar "date/time" the caption that pops up is all scrambled. Like instead of saying
"Tuesday November 15, 2005" it says "2005314". (Look at the included attachment) Also in Excel if I try to format a cell as a date in this format "DDDD MMMM DD, YYYY", the cell displays the year followed by similar characters like the text in bold. :)

I've been messing around alot with VBA, Visual Basic for Application, lately. I've been running a lot of not-quite-finished-lines of code. Could that have accidently corrupted a file. Yesterday when I was writing some code I clicked on the Coding Window and my computer was acting like it was frozen. I hit ESC and a dialog box popped up and said I interrupted auto-recovery. I exited the dialog box and later saved my file. I then looked at the file size, which I regularly have done after each coding session to make sure my code didn't increase too much in size. I realized that the filesize jumped from 250kb or over 3 Mb. Somehow interrupting autorecovery corrupted my original file, which I can understand, but could interrupting the auto save maybe corrupted a windows system file related to the the date?

EDIT: I just opened Outlook and noticed the dates across the calendar window are in the format 11-14 where the month and day are represented by there number.

Any ideas would be appreciated.

Thanks,
Urichjones

Attached Thumbnails

  • Weird_Caption.jpg
  • ExcelFormatCell.gif

Edited by urichjones, 16 November 2005 - 02:30 AM.

  • 0

Advertisements


#2
SpiritWind

SpiritWind

    banned

  • Banned
  • PipPip
  • 31 posts
:tazz: Have you clicked on "Date and Time" that is listed in your
"Control Panel" ? Is it current AND running ?
  • 0

#3
urichjones

urichjones

    Member

  • Topic Starter
  • Member
  • PipPip
  • 45 posts
I discovered my problem. Somehow my regional and language setting got corrupted. Thanks to a coworker's suggestion I opened regional and language options and the setting for long date was all messed up. I tried clicking it and editing it, but it was locked. So I just clicked on the drop down list for other setting and chose English(Zimbabwe) which showed up normal, then switched back to regular English. Now everything is back to normal. :tazz:
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP