![]() I'm on Excel 2011 14.4.7, and my operating system is OS X Yosemite 10.10.1. Wondering if my spreadsheet had somehow become corrupt, I closed it down and tried to build a simple similar process in a new workbook - still the same problem. If I compare the year in this value to the year today, for instance, it fails with invalid format. In VBA, if I refer to activecell.value and try to load it into a date variable, or display it in an input box I get '30/11/', and it really has lost the year. In the input box at the top of the screen I can see the date value of The cell would then show Sun 30/11/14, for example. Originally I used Custom format against the cell to show it as ddd dd/mm/yy. I'm in the UK and my dates are formatted accordingly. I've tried formatting the cell in different ways, using cdate to convert the text to a date, and using value2 but nothing works. Processing is dependent on date, but it now crashes because it cannot recognise the date. I have a macro originally written in Windows Excel, but I converted it to Mac 2 or 3 years ago and it's been running happily on a monthly basis until the first time I tried to use it in December.
0 Comments
Leave a Reply. |