Formatting of numbers in Excel output

When we pass in a field of double, float or integer type into Excel, Excel ignores our formatting and treat it as a number without the formatting we specified eg #,###.00 etc. To get around this, you need to append ' in front of the field so that Excel will treat it as String and show the number with the formatting.

Sample

-- Main.LeeYan - 02 Aug 2007