Geeks With Blogs

Tangible Thoughts SharePoint, MOSS? and all the other questions

Here is a basic tip

If you have a calculated field contains numeric data, SharePoint by default formats the field and displays it comma to separate the thousands.

This behavior can be overcome if you concatenate a string portion (or even a blank string i.e. &””) to the calculated field.

So using the example Michael Helland spoke about in the above link even =Year(Date)&”” will work too.

Posted on Tuesday, November 30, 2004 3:42 AM SharePoint | Back to top


Comments on this post: SharePoint calculated fields containing numeric data that are shown with a comma

# re: SharePoint calculated fields containing numeric data that are shown with a comma
Requesting Gravatar...
Thanks this really helped. What a frustrating behavior!
Left by Suzanne on Jun 22, 2005 4:32 PM

# re: SharePoint calculated fields containing numeric data that are shown with a comma
Requesting Gravatar...
Thanks... this really helped me too.
Left by Teresa on Aug 07, 2006 5:55 PM

# re: SharePoint calculated fields containing numeric data that are shown with a comma
Requesting Gravatar...
Thx for this post!
if you are getting the value from a column use this syntax
=Year([Column1])&""
Left by MyrO on Jan 14, 2008 9:04 PM

Your comment:
 (will show your gravatar)


Copyright © Tariq | Powered by: GeeksWithBlogs.net