Bound Columns -- "DataFormatString"

Important back pocket tool to have for formatting bound fields...

Reference MSDN --- http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.boundfield.dataformatstring.aspx

Note
In most cases, formatting depends on the server's culture setting. The examples are for a culture setting of en-US.

Format character	Description	Example
C or c	Displays numeric values in currency format. You can specify the number of decimal places.	Format: {0:C} 123.456 -> $123.46 Format: {0:C3} 123.456 -> $123.456
D or d	Displays integer values in decimal format. You can specify the number of digits. (Although the type is referred to as "decimal", the numbers are formatted as integers.)	Format: {0:D} 1234 -> 1234 Format: {0:D6} 1234 -> 001234
E or e	Displays numeric values in scientific (exponential) format. You can specify the number of decimal places.	Format: {0:E} 1052.0329112756 -> 1.052033E+003 Format: {0:E2} -1052.0329112756 -> -1.05e+003
F or f	Displays numeric values in fixed format. You can specify the number of decimal places.	Format: {0:F} 1234.567 -> 1234.57 Format: {0:F3} 1234.567 -> 1234.567
G or g	Displays numeric values in general format (the most compact of either fixed-point or scientific notation). You can specify the number of significant digits.	Format: {0:G} -123.456 -> -123.456 Format: {0:G2} -123.456 -> -120
N or n	Displays numeric values in number format (including group separators and optional negative sign). You can specify the number of decimal places.	Format: {0:N} 1234.567 -> 1,234.57 Format: {0:N4} 1234.567 -> 1,234.5670
P or p	Displays numeric values in percent format. You can specify the number of decimal places. (NOTE TO SELF --- System will perform calculation (n * 100) just provide the number. In other words (n1 \ n2 = n3)  n3 *100 will be handled by the Format {0:P}   Note alos {0:P0} will not produce decimals values.	Format: {0:P} 1 -> 100.00% Format: {0:P1} .5 -> 50.0%
R or r	Displays Single, Double, or BigInteger values in round-trip format.	Format: {0:R} 123456789.12345678 -> 123456789.12345678
X or x	Displays integer values in hexadecimal format. You can specify the number of digits.	Format: {0:X} 255 -> FF Format: {0:x4} 255 -> 00ff