| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Dates
I have a column of dates. These dates are stored in the cell as "112482" and
the cell is formatted as "00\/00\/00" so that in the cell it looks like: "11/24/82". The problem is, I can't sort these dates because they are not stored correctly in the cell for Excel to recognize them like it should. For instance, "112482" is seen by Excel as 112,482nd day after January 1st, 1900 or 12/18/2007. It appears there is no function in Excel currently to format my dates correctly so it can be sorted by Excel. Can I create one using VBA? What would it be? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting of Dates | Excel Discussion (Misc queries) | |||
| Formatting Dates | Excel Worksheet Functions | |||
| formatting dates | Excel Worksheet Functions | |||
| Dates Not Formatting as Dates | Excel Worksheet Functions | |||
| Formatting dates | Excel Worksheet Functions | |||
Threaded Mode
