Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
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 "2005Äê3ÖÄ14ÉÖ". (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