Skip to Content
0
Former Member
Mar 01, 2011 at 02:11 PM

Issue with Export to excel in WAD on 0CALYEAR and 0FISCYEAR

31 Views

Hi Gurus,

I have an issue here with Export to excel in WAD. When I click on Export to excel and open the excel sheet, 0CALYEAR is showing blank in the excel sheet but when I click on the cell the data 2010 shows up in the formula bar.

FYI - We recently had a patch upgrade from P17 to P22.

When I check my old excel sheet for the same report, I see that the same cell is showing the "format cell" option as "Text" but now its showing up as "custom". When I manually change it to text the current excel sheet is showing up the year in the cell.

This is happening with all WAD that has 0CALYEAR and 0FISCYEAR

Please suggest!

Thanks

Nisha