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


  1. support4u
    Posts : 43
    Windows 7
       New #1

    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 Computer
    Quote Quote

  3. DavidE
    Posts : 6,330
    Multi-Boot W7_Pro_x64 W8.1_Pro_x64 W10_Pro_x64 +Linux_VMs +Chromium_VM
       New #2

    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
    Last edited by DavidE; 08 Mar 2012 at 06:40. Reason: correction
      My Computer
    Quote Quote

  4. support4u
    Posts : 43
    Windows 7
    Thread Starter
       New #3

    Works like a charm.
    Completely overlookt the custom option.
    Thanks!
      My Computer
    Quote Quote

 

  Related Discussions
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...
Hi there, I would like to create a daily folder on system startup which has the date like this 12-03-2012 I also want it to go to a certain place on my hard drive C:Users/Name/My Documents I have this script but it puts the date the wrong way around and I would prefer dashes in between the...
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? ...
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...
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
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 06:20.
Find Us