Forum Discussion
Date Format
Hello, it is very likely that your entry is not a date but a text. This is supported by the fact that your TEXT() function does not produce a day of the week. No matter what number (and a date is really a number in Excel) is entered, a weekday should be displayed.
Please check your entry in the cell by calling the function
=ISTEXT(EL4)you enter. If the answer is TRUE, then it is a text that Excel cannot automatically convert into a number. This then leads to your error.
A good indication of the cell content is the formatting in the cell. If the alignment is not specified by manual input, text is always left-aligned and numbers and the date are always right-aligned.
I hope this has helped you.
Thank you for your reply.
How crazy, changing the date format is dependent on the alignment of the entry. I had a centre alignment of merged cells and the date dialogue box sample refused to identify the date format. Following your advice I reset the alignment to the right. Immediately the cell formatted to the date format I required, I then reset the alignment to centre. Problem solved.
I wonder why the cell format dialogue box does not take the alignment into consideration when showing a sample of the appearance!
Once again many thanks for your help, much appreciated, especially for my sanity.