Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: What is Excel Date Playing At?

05 Aug 2011   #1
RealGem

Windows 7 Home Premium 64 bit
 
 
What is Excel Date Playing At?

I wanted to put a date into a field, but did not want it formatted. In fact it could just represent any 6 digit number; not a date at all.

So I put 050811 (today's date the British way DD MM YY)

And Excel in its infinite wisdom changed it to:

10/02/2039

I despair!

It has done this before, which is why I did not want to put " / / " in the number.

But why would a 6 digit number be formatted and changed to a totally different date?

And how can I turn it off please?

thanks


My System SpecsSystem Spec
.
05 Aug 2011   #2
Irene

Windows 7 Home Premium 64bit
 
 

Try reformatting the cell/column to 'text' - it will then insert of '0' before the other digits and not insert the // in the date.
My System SpecsSystem Spec
05 Aug 2011   #3
RealGem

Windows 7 Home Premium 64 bit
 
 

Thanks Irene, that's great!
My System SpecsSystem Spec
.

06 Aug 2011   #4
Irene

Windows 7 Home Premium 64bit
 
 

Quote   Quote: Originally Posted by RealGem View Post
Thanks Irene, that's great!
You're welcome RealGem.
My System SpecsSystem Spec
Reply

 What is Excel Date Playing At?




Thread Tools




Similar help and support threads
Thread Forum
Microsoft Excel - The Date Bug
Hey all, Let me just start of by saying, this may be old news but it is still highly relevant in today's market. But there is a large bug in Office's suite all of them in fact (2000 - 2014), concerning the way it handles time / dates. History A brief bit of history for you all, MS decided...
Microsoft Office
Excel 2007 Date Factor
I have a spreadsheet of inventory items and the dates are in various formats Europe , USA , and Eastern. Example below. What I need to do is select all the dates and covert into one recognizable formula Month (1) Day (1) Year (****). Let me know how to do this. Thanks! 7/12/00 28/12/00...
Microsoft Office
Separating date and time in Excel Office 2007
I have Office 2007 running on a Windows 7 64 bit Toshiba laptop. I am trying to separate the data and time in an Excel file in one column and put the date in one column and the time in another. I need a "how to" procedure to do that.
Microsoft Office
Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy)
Yo folks, Annoying little thing in excel, I want to show the date exactly like this: 00-00-0000 (08-03-2012)(dd-mm-yyyy) Instead excel removes the zero's like this: 0-0-0000 (8-3-2012) (d-m-yyyy) Is it possible to keep the zero's? Thanks in advanced,
Microsoft Office
Excel 2007: a question about date and time manipulation
I have pasted data in to Excel that is in two columns Col A contains a list of dates, dd/mm/yy; col B times hh/mm/yy. How do I set about calculating and displaying the period in dd/hh/mm/ss that elapsed between col A row B with col B row B, and col A row C with col B row C ?
Software
Date Problem - Excel and Quickbooks
Hi For some reason, both my excel and my quickbooks will only output dates as dd-mm-yy I know that in excel, i can go to format cell>custom> mm/dd/yy. But, if i enter into the next cell, 1/30/2010 the computer does NOT recognize it as a date.. it sees it as 1st day of the 30th month in year...
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 02:36.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App