Tangible Thoughts

SharePoint, MOSS? and all the other questions

Home | Contact | Syndication

| Login

858 Posts | 6 Stories | 482 Comments | 2088 Trackbacks

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

# re: SharePoint calculated fields containing numeric data that are shown with a comma 6/22/2005 4:32 PM Suzanne

Thanks this really helped. What a frustrating behavior!

# re: SharePoint calculated fields containing numeric data that are shown with a comma 8/7/2006 5:55 PM Teresa

Thanks... this really helped me too.

# re: SharePoint calculated fields containing numeric data that are shown with a comma 1/14/2008 9:04 PM MyrO

Thx for this post!
if you are getting the value from a column use this syntax
=Year([Column1])&""