| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Because the cell is formatted as General, Excel perceives the entry to
be an integer number and trims off the leading zero. If you dig the mm/dd/yy date format, you can use this formula in a new column to parse the 10298 into an Excel date: =IF(LEN(A1)=5,LEFT(A1,1)&"/"&MID(A1,2,2)&"/"&RIGHT(A1,2),LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2)) .... where A1 contains the 10298. This formula checks the length of the entry and parses accordingly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How change the date format in the excel footer to dd mmm yy? | Excel Discussion (Misc queries) | |||
| Change FORMAT | Excel Discussion (Misc queries) | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
| change date function format in footer | Excel Worksheet Functions | |||
Threaded Mode
