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 2007 Date Factor


03 Feb 2013   #1

32 Pro
 
 
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 System SpecsSystem Spec
.

03 Feb 2013   #2

W7 Pro SP1 64bit
 
 

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 System SpecsSystem Spec
Reply

 Excel 2007 Date Factor




Thread Tools




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 12:53 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