| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formatting
I have an interesting problem. I have column "E" on my spreadsheet that shows
all cells with a comment tick with the information, 'Text Date with a 2-digit Year'. But when I try to programmatically correct this with a command like - ActiveSheet.Columns("E").NumberFormat = "mm/dd/yyyy" The format doesn't change my dates to reflect a four year digit. It will only change if I format another cell that has no comment tick and actually type in a date. Even if I copy and paste special-values into the other cell, the format remain in the 2-digit year. Anyone with a fix? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Formatting changes date | Excel Discussion (Misc queries) | |||
| Date formatting | Excel Worksheet Functions | |||
| date formatting | Excel Discussion (Misc queries) | |||
| Date Colum Date Formatting & Validation | Excel Programming | |||
Threaded Mode
