Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format "stuck"
Sometimes - especially when I copy/paste from Access - dates look like dates,
I can format the cells as dates, but they're not *really* dates. For instance, if I format the cell as a number, I should get the serial date. Or, if I change the date format from mm/dd/yy to m/d/yyyy, it should change. If I manually delete a /, retype it and hit enter, it suddenly recognizes it as a date. But, if I try to automate this workaround with a find/replace, it still doesn't recognize it as a date. What's up? I *really* don't want to manually do it with a thousand cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format "stuck"
Try DataText to ColumnsNextNextColumn Data FormatDate.
Pick from MDY or DMY or whatever will do the trick. Gord Dibben MS Excel MVP On Thu, 12 Oct 2006 17:11:02 -0700, Undrline wrote: Sometimes - especially when I copy/paste from Access - dates look like dates, I can format the cells as dates, but they're not *really* dates. For instance, if I format the cell as a number, I should get the serial date. Or, if I change the date format from mm/dd/yy to m/d/yyyy, it should change. If I manually delete a /, retype it and hit enter, it suddenly recognizes it as a date. But, if I try to automate this workaround with a find/replace, it still doesn't recognize it as a date. What's up? I *really* don't want to manually do it with a thousand cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell date format doesnt change | Excel Worksheet Functions | |||
Enforcing a date format on a cell/column | Excel Discussion (Misc queries) | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Customized Date Format | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) |