Custom formatting not functioning in Excel
 

I have an Excel sheet in which date related formulae were working properly.

But now the Format-Cells-Custom- ddd, d/mmm/yyyy is not accepted by Excel.
Date related formattings are not accepted.

I have uninstalled Office, defragmented, and reinstalled Office. But problem
still persists.
Please help me

Custom formatting not functioning in Excel
 

What do you mean with "not accepted"? What message do you get?
If the format is accepted but you don't see what you expected, check if your
number isn't text (although it may look like a number) with the ISTEXT()
function

--
Kind regards,

Niek Otten

"Seenath" wrote in message
...
I have an Excel sheet in which date related formulae were working properly.

But now the Format-Cells-Custom- ddd, d/mmm/yyyy is not accepted by
Excel.
Date related formattings are not accepted.

I have uninstalled Office, defragmented, and reinstalled Office. But
problem
still persists.
Please help me