Crazy Date In Excel Cells

[jksb]

I formatted cells for date mode; when I type in the date, say, 06/06/00, I get wacky dates, like 11/29/2065. I feel like I'm in a time warp! Please help!

Thanks!

Jackie [sig][/sig]

 

[Dreamboat]

Select the column, hit Edit-Clear-Formats, then start over with your formatting.

If that doesn't work, it sounds like something's wrong in your regional settings. Is there any VBA code in the file? Hit alt-f11 to check, doubleclick each worksheet. [sig]<p> <br><a href=mailto:techsupportgirl@home.com>techsupportgirl@home.com</a><br><a href=

http://www.wedomanuals.com>

</a><br> [/sig]

 

[jksb]

Thank you! I did Clear Formats, the original date I typed in came up (without the slashes, etc.); I deleted it, went back to format, date, etc. Put in the date; same thing happened with the crazy dates. Did AltF11 and the VBA Project screen came up, but each worksheet was empty when I clicked on it.

Help!

Jackie, in the Year 2525 [sig][/sig]

 

[Dreamboat]

Excel may not be seeing (may be REFUSING to see...) the contents of the cell as anything other than text. To force it, type a date in one of the cells.

Put a 1 in any blank cell somewhere else. Copy the cell with the 1 in it. Go to the cell where you typed the date that looks like 2525. Hit Edit-Paste special and select multiply. If the date comes up right, let me know.

If you still can't get a date out of it, you're certainly welcome to email your file to me. I WILL fix it, one way or another.

[sig]<p> <br><a href=mailto:techsupportgirl@home.com>techsupportgirl@home.com</a><br><a href=

http://www.wedomanuals.com>

</a><br> [/sig]

 

[jksb]

Thank you! Sorry for not getting back yesterday...power went out all day .

I went to edit/paste/special..and have only two options: Unicode Text and Text. I tried pasting as Unicode Text, it did the number as 01/01/01, but when I went to type in 06/06/00, back to the same again. Where do I get mulitply from?

Thank you!

Jackie

 

[paulovey]

Hi,

Could be the windows date bug, sounds as though you have the wrong reginal settings.

Lets assume you are in the UK, if you check the region it will probably say UK, but it will be using US settings.

To change this you need to change the region to US reboot, and then change to UK and reboot again.

This should put it in to the correct region, and try again with the dates in excel..

 

[jksb]

Thanks..tried it, still trying to put me back into the future (sorry, I just couldn't resist). It's Win 95 BTW, and Office 97 (probably should have mentioned that in the first place). Any other ideas? This is driving me a bit crazy as I need to have this ready tomorrow.

Jackie

 

[jksb]

Oh, and I am in the US.

Jackie

 

[Dreamboat]

Jackie: What happens when you take a brand new spreadsheet and format the columns as dates and enter the dates in the new one? Same thing? You're still welcome to email the file...


techsupportgirl@home.com

http://www.wedomanuals.com

 

[jksb]

Yup, still does it. I will be emailing you as my company is setting up a company email for me today

Thanks!

Jackie

 

[maddycd]

If you format the cell/column to date and type 060600 you will get 11/29/65. The "Date" format represents the date in excels' date-time code. If you type 06/06/00 it will show it that way.

I haven't found an answer for this yet except to type the date with the slashes.

 

[cheerio]

Dates are stored in Excel as the number of days since the start of 1900 (or possibly since 1904).

60600 days since 1900 is Nov 29 2065.

The leading 0 in 060600 is not relevant - you are simply typing the number 60600 and asking Excel what that means as a date.

 

[RoyVidar]

You are aware you are answering a question from the year 2000?

Roy-Vidar

 

[klmorgan]

Has Batman spun the world backwards again?

Keith