Hello

I’m using an Excel Ghant Chart template from Excel – I’ve added a line to add in mmm-yy and it displays as the 5 digit serial number.  The cell is formatted as a Custom mmm-yy, but still displays as the 5 digit number.  When I click on the cell the formula bar shows the date but the cell doesn’t.

I’m wondering if it’s locked as it is a ‘standard’ template.  I can see a lot of Naming conventions have been applied throughout.  Does anyone know what the fix may be?

Thanks in advance

April

​HelloI’m using an Excel Ghant Chart template from Excel – I’ve added a line to add in mmm-yy and it displays as the 5 digit serial number.  The cell is formatted as a Custom mmm-yy, but still displays as the 5 digit number.  When I click on the cell the formula bar shows the date but the cell doesn’t.I’m wondering if it’s locked as it is a ‘standard’ template.  I can see a lot of Naming conventions have been applied throughout.  Does anyone know what the fix may be?Thanks in advanceApril  Read More

​