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

Microsoft Windows 7 Professional 64-bit 7601 Multiprocessor Free Service Pack 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!

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

 Excel 2007 Date Factor

Thread Tools

Similar help and support threads
Thread Forum
Excel 2007 Files Are Now Saving with Fewer KB in Both Excel 2007 and 2
The “problem” I’m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb. I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit. The W700 has Office 2007 and theW541 has Office 2013. Both versions ofExcel are 32 bit as far as I...
Microsoft Office
Separating date and time in Excel Office 2007
I have Office 2007 running on a Windows 7 64 bit Toshiba laptop. I am trying to separate the data and time in an Excel file in one column and put the date in one column and the time in another. I need a "how to" procedure to do that.
Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
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 ?
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office

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