Philip has attended:
Excel Intermediate course
Dates
Hi,
I would like to know if there is an easy way to convert a date in text format to a microsoft date number. I have tried formatting the cell as a date - it works when I edit the cell and then press enter but with a big spreadsheet this isn't really an option.
I can also achieve with a formula but this means creating another sheet and then adding the formulae. Bit time consuming and therefore not ideal.
RE: Dates
Hi Phillip,
Thank you for your question.
There is no easy way of applying this formula to random cells in a spreadsheet withhout the use of a macro written in the VBA application which is beyond the scope of this forum question.
However, you can use the DateValue function to convert or maybe CDate or even Indirect.
I hope this helps.
Regards
Simon
