Hi all,
i'm in the situation that I need to export an excel file from C11 that does not observe my system's settings for number formatting. I.e., my PC is setup in German, so decimal delimiter comma and thousands delimiter point, but I need to export a number column with decimal delimiter point and thousands delimiter none.
I know that I can pretty much forget plain data formatting within Cognos; if excel recognizes the column as number, it ignores whatever cognos formatting is there and applies its own. So I thought I can just cast the value as varchar(99), but now the values come through as scientific notation, e.g., 182.144 becomes 1.82144E+02.
Is there any way I can get what I need?
If you export it as a CSV and open the CSV in an editor such as notepad++ what does the data look like?
Quotebut now the values come through as scientific notation,
In Excel or Cognos?