| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date conversion issue... again
Hello all,
I have a file that contains dates. I know that for example "12.10.2004" means "December 10th, 2005", however Excel treats as "Oct. 12th 2004". Nothing works: converting the format of the cells doen't help, the TEXT(A1;"mm.dd.yyyy") doesn't do anything because it works on the serial number instead Any suggestions? thanks a lot |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
| Date Conversion | Excel Worksheet Functions | |||
| Date conversion issue "^" symbol | Excel Discussion (Misc queries) | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Threaded Mode
