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: Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy)

08 Mar 2012   #1

Windows 7
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,

My System SpecsSystem Spec
08 Mar 2012   #2

Multi-Boot W7_Pro_x64 W8.1_Pro_x64 W10_Pro_x64

what i think you want is to format the cells with a custom format...

Use dd/mm/yyyy for the Type

edit: use dd-mm-yyyy for the Type
My System SpecsSystem Spec
08 Mar 2012   #3

Windows 7

Works like a charm.
Completely overlookt the custom option.
My System SpecsSystem Spec


 Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy)

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
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Microsoft Excel 2010 - chart formatting question
Hello, I've just made a pretty decent scheme in my Excel. It's all good but I would like it to fill a whole A/4 sized piece of paper, by increasing the size of the cells as well as the text in them proportionally, so that I don't have any unused, blank cells. Is there a simple way to do this? ...
Microsoft Office
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! :confused: :eek:
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
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 ?

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 22:24.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App