Excel 2007 Date Factor


  1. Posts : 76
    Microsoft Windows 7 Professional 64-bit 7601 Multiprocessor Free Service Pack 1
       #1

    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
    21/12/00
    21/12/00
    26/12/00
    28/12/00
    23/01/01
    25/01/01
    04/01/01
    11/01/01
    1/2/2001
    6/1/2001
    27/01/01
    8/11/00
    27/01/01
      My Computer


  2. Posts : 10,485
    W7 Pro SP1 64bit
       #2

    select the cells of interest
    right click within that selection
    select Format Cells... from the context menu
    select Custom from the Category: column
    select m/d/yyyy from the Type: column
    select OK to close and apply the formatting
      My Computer


 

  Related Discussions
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 11:16.
Find Us