|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 16th, 2002, 09:14 AM
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 2
|
I use excel for calculating wages for a large group of people in a company.Each person has a card for tax deduction purposes and each week on the card has a date which was formatted dd/mm/yy. For no apparent reason all the dates in all the Excel workbooks have changed to mm/dd/yyyy. I recently took a Microsoft Excel test on line. Could this have caused the changes to happen? Is there an easy way to revert back to the original dd/mm/yy, without having to correct each individual sheet, as I have hundreds to undo?
|
|
|
|
Apr 16th, 2002, 09:25 AM
|
#2 |
|
Board Regular
Join Date: Feb 2002
Location: Ahmedabad Gujarat
Posts: 303
|
May be two reasons..
you must have changed your system date format.. or you must have changed the format of your cells ... nishith desai http://www.pexcel.com |
|
|
|
|
Apr 16th, 2002, 10:14 AM
|
#3 |
|
New Member
Join Date: Apr 2002
Posts: 2
|
Thank you for your advice on my date problem with Excel. However, if you take the Excel on line test from measureup.com and have your regional seettings to dd/mm/yy, they will change to m/dd/yyyy.
joe spencer |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
