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

Win 7 Pro x64 SP1, Win 7 Ult x86 SP1
 
 

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.
Thanks!
My System SpecsSystem Spec
.


Reply

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




Thread Tools



Similar help and support threads for2: Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy)
Thread Forum
Excel 2007 Date Factor Microsoft Office
Microsoft Excel 2010 - chart formatting question Microsoft Office
Solved What is Excel Date Playing At? Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel 2007: a question about date and time manipulation Software
Date questions...Excel 2007 Microsoft Office
Date Problem - Excel and Quickbooks 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 07:25 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33