URGENT-weird format of dollars-

[Sep2013]

Hi frends,

i have developed a report but it shows some awfull format for numbers as attched and highlighted.
please help me to resolve this.

[CognosPaul]

It looks like a data problem to me.

7.27595761E-12 = 0.00000000000727595761

Cognos doesn't generally render numbers with that level of detail, it rounds it using exponential notation.

Find out what the value should be and you'll be on your way to solving the problem.

[Sep2013]

this ones resolved by just setting the white space to "No Wrap" but, now wehn i export the output to excel some of the coulumns doesnt show up numbers.I mean blank in a column whereas there are values in html output