Numbers showing as text in Excel

[Ariana]

I am using the following statement to give occurrences a numerical value but when I pull into Excel it identifies it as text. How do I get it to send the data to Excel as a number? Fixing manually in Excel is not an option. Here is my statement:
(CASE WHEN
[Loans].[LN Master].[Participation Code (LNMA)] IN ('s','S')
THEN
'1'
ELSE
'0'
END)
I appreciate any assistance.
Thanks,
Ariana

[MFGF]

I am using the following statement to give occurrences a numerical value but when I pull into Excel it identifies it as text. How do I get it to send the data to Excel as a number? Fixing manually in Excel is not an option. Here is my statement:
(CASE WHEN
[Loans].[LN Master].[Participation Code (LNMA)] IN ('s','S')
THEN
'1'
ELSE
'0'
END)
I appreciate any assistance.
Thanks,
Ariana

Hi,

Have you tried:

(CASE WHEN
[Loans].[LN Master].[Participation Code (LNMA)] IN ('s','S')
THEN
1
ELSE
0
END)

MF.

[Ariana]

 :o Thank you so much! You would be amazed how many people tried to fix this and failed at my place of business. In retrospect, it is all kind of silly.

[MFGF]

:o Thank you so much! You would be amazed how many people tried to fix this and failed at my place of business. In retrospect, it is all kind of silly.

Happy we could help! Let's hope it earns you some kudos at work for being the one to solve it :)

MF.