cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

could anyone please help me on this issue?