Keep trailing zeroes in pivot table

[Blackadder2000]

Hi,

I have a pivot table with text (varchar in SQL) measures which are displayed with Only(Measure). For numbers all trailing zeroes in the decimals are removed. Any idea how I can keep all trailing zeroes and keep the source formatting?  

[Anil_Babu_Samineni]

Try these

Only(Num(Measure, '#,##,#0'))

Or

Only(Text(Measure))

[Blackadder2000]

None of the examples worked out. The first just results in 2 decimals regardless if the original data contains any decimals or not. The other also removes the trailing zeroes.

The original data in the SQL Varchar column looks like this:

7,35

7,40

7,50

7,51

The data shown in the excel pivot with Only(Measure) is shown as:

7,35

7,4

7,5

7,51

The result will not always contain 2 decimals so I need a general function that can keep the source formatting including the trailing zeroes for text (varchar) results.

[Blackadder2000]

Any other idéas?