1
vote
2answers
175 views

How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?

My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format. I tried to format using Excel custom date format and built-in ...
1
vote
2answers
6k views

How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL? (Still didn't got satisfactory answer)

I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type ...
1
vote
1answer
101 views

Stop Microsoft Excel 2007 from formatting anything?

How can I stop Excel 2007 from modifying any character, I don't want to modify the date in any way, I don't want to modify misspells, nothing. I just want to see the exact text I'm writing.
8
votes
1answer
15k views

Adding Weeks to Current Date in Excel 2007

How can a given number of weeks be added to the current date in Excel 2007? For example, if I need to add 12 weeks to the current date, 12/6/2010, how can that be done?
4
votes
1answer
5k views

Grouping dates by week in a Pivot Table

I am trying to create a Pivot table to report on data that comes from an Access Query. Basically the data that comes back is in the following format: TradeDate StoreID DeptCode ReasonCode ...