Joe Webb Blog

Musing and observations about SQL Server, other technogies, and sometimes just life in general

Formatting strings

I just completed teaching a Microsoft SQL Server Reporting Services class in Charlotte, North Carolina - a wonderful and beautiful place to visit!

In a couple of the demonstrations, we used some predefined formatting strings to customize the way a user can see a value in a report. For example, we used C0 to display a currency value with no numbers to the right of a decimal point.

One question that almost always comes up during the class is: where can I find a list of those predefined formatting strings?

Microsoft has them on the MSDN Library site, but the are buried and rather difficult to find. So, I thought I'd share them with you here. These links are for v2.0 of the .NET Framework, however these pages include links to other versions including v1.1, v3.0, and v3.5 of the .NET Framework.


Enjoy!

Joe
kick it on DotNetKicks.com

Legacy Comments


John S.
2008-03-13
re: Formatting strings
I made those into cheat sheets: http://john-sheehan.com/blog/index.php/net-cheat-sheets/

Jeff
2008-03-15
re: Formatting strings
Good stuff, Joe, this will help those who somehow feel that it is just "easier" to format via converting everything to VARCHAR within the database!

Dan
2009-01-14
re: Formatting strings
Thanks, I've been looking for these!